Copy paste from multiple workbooks to master sheet

[a1b2c3d4]

EE Name	EE ID	Age		Educ. Ql.	Experience	Tenure		Activites	Time	Group
Abc	12345	22		Commerce	5 yrs	7		Time & Attendance	9:00:00	HR
XYZ	78965	18		Arts	2 yrs	5		Payroll	6:00:00	Finance

<tbody>
</tbody>

In above table, first three columns are part of Sheet1, other 3 columns are part of sheet2 and last 3 columns are part of sheet3 of the same workbook.
I receive the data in three worksheets from 21 locations which means 21 workbooks X 3 worksheets = I need to open 21 workbooks and from each workbook I need to copy 3 times from each workbook to paste into my master sheet which is in the same format with three worksheets for pasting the data one below the other by ensuring data doesn't gets override.
Is there a macro with which once I open the workbook, the macro copies the data from all the three sheets and paste into my master sheet in all the respective 3 worksheets one below the other without overriding the existing data. Please assist.

 

[cpatel13]

EE Name	EE ID	Age		Educ. Ql.	Experience	Tenure		Activites	Time	Group
Abc	12345	22		Commerce	5 yrs	7		Time & Attendance	9:00:00	HR
XYZ	78965	18		Arts	2 yrs	5		Payroll	6:00:00	Finance

<tbody>
</tbody>

In above table, first three columns are part of Sheet1, other 3 columns are part of sheet2 and last 3 columns are part of sheet3 of the same workbook.
I receive the data in three worksheets from 21 locations which means 21 workbooks X 3 worksheets = I need to open 21 workbooks and from each workbook I need to copy 3 times from each workbook to paste into my master sheet which is in the same format with three worksheets for pasting the data one below the other by ensuring data doesn't gets override.
Is there a macro with which once I open the workbook, the macro copies the data from all the three sheets and paste into my master sheet in all the respective 3 worksheets one below the other without overriding the existing data. Please assist.

Hie,
That's possible but need certain information, whatever data you receive from all the locations, are those data updated regularly, i mean to say when they send you a file does the data start from A1 or from where it has been left last time. i hope i am clear, if any doubt do reply.

 

[a1b2c3d4]

hello, the data which i receive each month starts from A1

 

[cpatel13]

hello, the data which i receive each month starts from A1

Would all of your workbooks which you would be receiving would have all the same sheet name, for instance sheet1, sheet2, sheet3 for all your 21 different workbooks. Also as you have told me your data starts from A1, so it means the files which you receive does not have headers, i hope i am clear.


Regards,
Cpatel13

 

[a1b2c3d4]

Dear Cpatel13, any help on my query.

Would all of your workbooks which you would be receiving would have all the same sheet name, for instance sheet1, sheet2, sheet3 for all your 21 different workbooks. Also as you have told me your data starts from A1, so it means the files which you receive does not have headers, i hope i am clear.


Regards,
Cpatel13