Consolidated Tabs from Many Spreadsheets into One

Hello,

I have 5 spreadsheets in a single folder at this directory: "C:\Desktop\Folder" (for instance).

One of the workbooks is a master spreadsheet "Master.xlsm" and the others are "Individual1.xlsx", "Individual2.xlsx", "Individual3.xlsx", "Individual4.xlsx".

Can I consolidate all of the tabs from each individual spreadsheet as separate tabs in the "Master.xlsm" file? The key is that the number of individual spreadsheets will change, and they will have dynamic file names, so it would be best if the macro specified a folder, not individual workbook names.

Thank you,
Matt

Figured it out:

Please Login or Register  to view this content.