VBA Code to Copy data From 13 Workbooks from specific sheet and paste it to master file one below another.

[Gogo007]

I have a folder having total 13 workbooks with same sheet name "Annex 2" .
I need to open each single workbook (from those 13 workbooks) and need to copy data from column A to P from Sheet "Annex 2" and need to create a new Master file and paste into it.

Please help me out with this.
Thank you in Advance !

 

[Marc L]

As the classic slow way can be achieved by any Excel / VBA helper even beginner …​

​

But if you need a faster way zip some source workbooks and accordingly the expected result workbook and link it at least on a files host website like Dropbox …​

 

[Gogo007]

As the classic slow way can be achieved by any Excel / VBA helper even beginner …​

​

But if you need a faster way zip some source workbooks and accordingly the expected result workbook and link it at least on a files host website like Dropbox …​

Thank You for the inputs Marc but VBA would be better option for me as I need to develop more on VBA code basis.
But if you can please help me with VBA code.

 

[Marc L]

​

As I stated for a VBA procedure so all is yet in my previous post …​