Hi - hoping someone knows a good way to do this. Any help would be much appreciated.
So i have a bunch of excel files with various names, all containing the filename subfile, i simply want to open them all, get every tab, put all those tabs into the same workbook. The workbook I want them all in already exists, and ideally will be updating each time i do this monthly, so I want to overwrite tabs that exist with the same name as the ones incoming from the subfile excels.
There's 1 or 2 tabs in each subfile workbook.
Hope that makes sense.
Thanks
ste
So i have a bunch of excel files with various names, all containing the filename subfile, i simply want to open them all, get every tab, put all those tabs into the same workbook. The workbook I want them all in already exists, and ideally will be updating each time i do this monthly, so I want to overwrite tabs that exist with the same name as the ones incoming from the subfile excels.
There's 1 or 2 tabs in each subfile workbook.
Hope that makes sense.
Thanks
ste