VBA Code to Open Workbook and copy data

[Howardc]

I have several workbook that I need to open and copy the data into sheet1 of the destinational workbook

All the headers in the source workbook are the same

I would like VBA code to do the following

1) To copy the data including headings from the first workbook in sheet1 on the destination workbook
2) All subsequent workbooks, except headers to be copied in the row after vwhere the previous data has been copies

I have attached a sample workbook

Your assistance in this regard is most appreciated