Macro to copy data from multiple workbooks to new sheet

[Venkat1067]

HI I would wonder if anyone can help me to solve this..

I have 10+ excel files in folder, each workbook contains worksheet named as All Levels, I want to copy data in All Levels sheet to Sheet 2 in my new workbook.

 

[Macropod]

How is this different from what you asked in:
https://www.mrexcel.com/forum/excel...nto-new-spreadsheet-along-refresh-option.html
and:
https://www.mrexcel.com/forum/excel...ultiple-workbooks-copy-data-column-2-4-a.html

I note also that you posted this question twice. Kindly read Mr Excel's policy in Rule 12 against posting duplicate questions: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html