Copy data automatically from multiple sheets

[CoolerOconnor]

Hello. Glad to find this forum!!!

I have about 38 users each with one excel workbook that contains the 3 sheets.

I would like to create a MASTER Workbook where I can have the 3 tabs and that can automatically update the information inserted in each workbook.

for example if one of the tabs is labeled reports and 3 users add a report simultaneously, I'd like my master workbook where I save all reports to automatically update with the info just typed.... if it's right away great else I could set a timer to refresh every few seconds.

Help!!!

 

[CoolerOconnor]

I currently do this manually and it is a job itself!!! Assistance is greatly appreciated in advance