VBA Loop - duplicate header copied over

[cynthi263]

I am wanting this code to loop through various files in a folder and copy info from each file and paste to a master file - my issue is that after it opens the first file and moves on to the second one, it will paste the header in there as well. All data starts on the same cells "A5" in all the files (A4 is the header) and the header in the master is already added. It only does this on the 2nd file, when it opens the others, it copies just the data and pastes it correctly. Not sure why it's only happening on the 2nd file?

I have tried running it with different files and it doesn't matter which it is, the 2nd one always copies over the header and pastes it in the master file.

 

[Zot]

I don't really understand what you were doing here from code. The wb is the workbook where you get the data from, right?

Then why you have another one Workbooks.Open statement? Is this to open Master file? Your code is on another workbook?