Hi, I am a novice excel user.

I am trying to set up a master document containing multiple worksheets where for each worksheet a separate workbook is created and is updated each time the master is updated.

For Example

Master Workbook contains 4 worksheets (Site1, Site2, Site3, Site4).
Then I split the Workbook ending up with 5 document files in total (Master, Site1, Site2, Site3, Site4).
Then I create a shortcut / link the Site1 worksheet in Master to the file Site1 and whenever an update is made in either the master file or the Site1 file.

Many people access and update the information contained in these files. It needs to be a simple process as many of the users are not overly confident with using the product.
The goal is to send certain information for each site to specific personnel however also allows all the information to be sent to the Coordinator of all sites without sending 4 separate files or having to merge the separate files each day to maintain an up to date master.

Is this possible? Can anyone give me some instruction on how to set this up please?