Strictly speaking creating this kind of link spreadsheet system is not best
practice because it lacks data audit control. when the result changes you
will have no idea why etc etc.

My suggestion would be to create the whole thing, which I think you've done.
then create copys for the managers as stand alone templates v0.1.

when they send you back a completed template copy the entire sheets contents
over the older version, and mark them as v0.2 where approriate.

Keep saving the whole thing too as different versions and you will have
yourself a nice audit trail

In the words of a man who knew, external links are bad practice full stop


"Django" wrote:

Good day, appreciate any assistance that you can provide. I am working on a
finle which consists of 8 tabs representing business units. I would like to
create separe files representing each business unit to send to the managers.
I would like whatever data the managers input be reflected on the
corresponding sheet in the main file. Appreciate it if anyone could tell me
how to link the files and make the changes interactive.
--
Django