Hi I have multiple workbooks named for example H0_2016-07-01 so for each day of the month for every month, they all in the same file so I want to merge all the workbooks in this file into one one workbook called H0
They all have "Controls" as the first worksheet then data on every sheet after this first sheet. I don't want to copy the "Controls" sheet from each file, I just want to copy all the other worksheets.
Could any help with some VBA for this please?
Bookmarks