Loop to copy the same rows from multiple files to a master file

Thank you so much for this. It works well- I could never have written that myself!

The only issue is that I would like to be able to get the code to loop through every Excel file in the folder (i.e. get the source file to change). However, when the code runs through these files, the information from each file needs to be copied to a common (master) sheet for each site (e.g. WM-01) (i.e. the sheet created during the first loop), rather than opening a new set of sheets for each file.

For example, row 4 from both the attached files ('SWM_example1', 'SWM_example2') needs to be copied to the same 'WM-02' sheet (which was created by your fantastic code, shown in your example, 'SWM_example(bvj)'), rather than creating a new 'WM-02' sheet everytime the code loops.

In my mind you are already a genius, but if you can help me with tweaking the code to do this, you will be STELLAR.

Many thanks