Copy data automatically from multiple sheets

CoolerOconnor

New Member
Joined
Jan 21, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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!!!
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

CoolerOconnor

New Member
Joined
Jan 21, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I currently do this manually and it is a job itself!!! Assistance is greatly appreciated in advance
 

Watch MrExcel Video

Forum statistics

Threads
1,127,663
Messages
5,626,163
Members
416,166
Latest member
Archimed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top