I am trying to combine multiple .XLSX files, each file has a different file name, different schema, different tab names. All I need is combine all sheets from these files into one file keeping the tabs the same as in the individual workbooks. I have read that I need to use a macro, however I do not know where to begin. I am a newbie. Thanks.
Check out the above link.