Hi All,
I have 20 workbooks all located in a folder. In each workbook, worksheet #4 is called "4. Class Data".
In a master workbook, I'd like to import each "4. Class Data" sheet only.
I'm after a VBA macro which can process this.
I've started with this:
[code]
This doesn't work, and I think it's because the master sheet can't have 20 sheets all named "4. Class Data". Ideally, I'd love for the sheet name being imported from a given workbook be renamed to, for example, the 2nd word of the file name it's coming from, as this will be unique.
I've obviously changed the file path for sensitivity reasons, so I know that's not the issue.
Any help would be great. Thanks
Bookmarks