Hi
personally this does not sound that Excel is the right application for you.
You may consider using a database for this kind of task

--
Regards
Frank Kabel
Frankfurt, Germany

Chaplain Doug wrote:
Excel 2002-2003. I have a master workbook that contains 75 sheets.
Each sheet
represents a territory. I have six persons, each of which is
responsible for a subset of these 75 territories. I want to create
six workbooks, that derive their data from the master workbook. Each
of these workbooks will have about a dozen sheets, My question is
this: How can I create these six workbooks such that the sheets in
these workbooks point back to the sheets in the master workbook? I
know how to make cells point to cells in other workbooks. But I want
to make the whole sheet point to another sheet in the master workbook
and thereby always duplicate the master sheet. How may I do this?
Thanks for the help.