If you try something like this, I think you're setting yourself up for failure.
Way too many things can go wrong.

I would take a different approach.

Put all your data in one worksheet (the parent worksheet). Do all your data
entry there. If you need to view different "slices" of your data, maybe you can
use data|filter|autofilter to view the stuff you want to see.

If you absolutely must have multiple sheets, then I would still keep the data in
one worksheet (and update it there), but use a macro to split the parent's data
into each of the child worksheets.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

JasonG wrote:

Thank you in advance to anyone who attempts to answer this post. I have a
total of 6 excel spreadsheets that I would like to link to each other. 5 of
them could be considered 'child' sheets and one 'parent' or master sheet. On
the 5 child sheets, each will contain text and numbers and a sum at the end.
On the parent sheet I would like to have 6 tabs. One tab for each child
sheet that is a constantly updating copy of changes made in child sheet.
After those 5 tabs I would like to have a 6th tab that is a grand total of
the previous 5 tabs. It should contain copies of all the other 5 tabs, one
on top of the other, and then a sum total at the end.

I would then like to have a copy of that 'total tab' on 2nd tab on each of
the child spread sheets. Is something like this possible?

--

Dave Peterson