Hi all

first up, really appreciate any help on this. I am trying to merge a series of files where the column structure is the same, using the code at this link (sorry it isn't an actual link, I am not allowed until my post count is 5):

joinedupdata.com/the-ultimate-guide-on-how-to-merge-excel-files/how-to-merge-excel-files-with-the-same-columns

However, the data that I have has a couple of quirks -
1. Each file has about 15 sheets but it is only one sheet which I would like to extract into the merged file
2. the table headers are on row 2 of each file - row 1 is blank

I have tried a few things but have not been successful - I don't have too much coding experience. Many thanks in advance!

Chris