Merge all tabs in multiple workbooks into current workbook

[steallan]

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