Need to setup links of entire tabs from 1 master spreadsheet to multiple subsidiary sheets

I have a master workbook with multiple executives' metrics and dashboards. I'd like to be able to set up individual workbooks with the respective executive's dashboards and these workbooks be automatically updated after changes to the master workbook. The dashboards have links to other spreadsheets, input cells for action plans, and charts.

Any other information needed to assist?

Thanks in advance for your help.

Shawn

If anybody believes this isn't possible, that would also be extremely helpful. I'm at a loss, and if I can't get it to work, I'll have to move on to another solution.

Thanks again for taking a look.

Shawn