Please could you send me a data transfer link as I can't download excel spreadsheet from here.
Did you get everything you need?
Okay, 4 different workbooks sit in a folder(internal link).
All in one folder.
1 name - example test1
2 name - example test2
3 name - example test3
4 name- example test4
If it helps you. You can put example data in. This data will contain various rows depending on the day- usually about 2000 rows down and 10 columns.
So the macro will look into the folder and copy and paste example test 1(spreadsheet) into tab2 (of the spreadsheet I send you) then it will do the same for example test2 into tab 3 on so on.
Hope that makes a bit more sense. Let me know if it doesn't and I try to simplify.
Okay- That's fine. Please go ahead.