Copy data from multiple workbook in one new workbook.

Dev saini - Apr 5, 2017 at 05:01 AM

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.

Dev Saini