Hello,

I am relatively new to VBA but understand basic coding. I currently have code that will open a file location and open all the files within a folder based on userform entries. What I really need help with is how to copy the data from the first sheet of each of the opened files and paste them in their respective sheets in one workbook. For example:
I open all files each named: “1”, “2”, “3”, etc. The number of files being opened is varying.
I want to copy the data from workbook “1” and paste the data into Cell A5 of sheet 3 in a separate workbook (3 is not the name of the sheet but the sheet number)
Then I want to copy the data from workbook “2” and paste it into Cell A5 of sheet 4
And so on...
The number of sheets created in the single workbook is based on the number of files in that location so there will always be enough sheets in the other workbook.