Copy dynamic data from worksheet to another identifying by the name of worksheet

[c.wang]

Hi All,

I need to copy a specific worksheet (identified by its name) present in all workbook located in a folder.
1) Worksheet is identified by name "Data*" (it could be "Data -Region", "Data Country" etc). There could be multiple worksheet with name starting with "Data something" in a workbook.

2) The data needs to be copied starting from Row 17, Column A to N. Since the data is dynamic there is no particular range to copy. (There could be empty rows in the data that needs to be copied)

3) Append & paste data in the workbook where the macro resides.

In summary, I'm copying & creating a master list of the data present in specific worksheet in all workbook present in that folder.

Tough side of it is copying the dynamic data with empty rows in between.

The attachment is the code I modified.

Any help would be Greatly Appreciated.

Thank you all in advance.

Wang