Combine information from several files

[fataemorganae]

Hi guys,
Have a file that is shared (lucky me... not) but always having troubles cause people at this company are a bit dummy when it comes to use excel books...

I was thinking of having a copy for each user that everytime they make changes, it will show at the Main File.

Any simple way of doing it?

A few years back i've done in in Acess... All micro files pointed to the Master, but the changes were seen in all of them...

Is it possible in excel? How?

All computers are with Office 2016Pro and Win10

 

[oldbrewer]

maybe let each user have a sheet in your master file, password protected so that only they can make changes to any cells. You can pull info from those sheets into your master sheet.