Hi Everyone, thanks for taking a look

I have 4 spreadsheets with the same name (but different week number) and every month I have copy data from one of the sheets within these spreadsheets and copy to a new spreadsheet to create a report for that month. It takes ages as there are a dozen different things I have to do this to.

All the data for each week is stored in the same place on each sheet.

How do I make a code that will copy this set piece from each week (the week to be specified on a list in excel, as people who don't know vba and macros would be using it) and then copy into one table, so I can use pivot tables etc on these.

Does this make sense? Really appreciate the help everyone!

Martin