I'm new to using VBA, but I found the code shown below on the internet which allows you to select specific files that you choose and copy the data into a new file which is used as a summary.
Firstly, I need to amend the code so that rather than create a new file it pastes the data into a sheet...