VBA Code to Open Workbook and copy data

[Howardc]

Hi

I have re-tested the code and It would be appreciated if you could make the following small change. The first row of the data contains the Branch name and the decsription. the second row contains the row headings. The first row must be ignored. The headers in the second row must be extracted for the first file and the rest of the files from row three onwards

I have attached sample data of one of the source workbooks as well as what the data extraction looks like in the destination workbook