Copy data from multiple workbook in one new workbook. [Closed]

Report
-
Hello,

I have 10 workbooks and have data on Sheet 2 with same Title from Column "B2:N2".
All workbooks are in one folder.
I want to create a mastersheet for all workbooks so i can get data from all workbooks in this mastersheet.
Data is store in Sheet 2 in all workbook.
Data Title is same so i want to collect all data in sheet 1 in Mastersheet.
when anybody add data in those workbook so data will copy in that master sheet.

Please tell me macro for that.

Regards
Dev Saini

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!