Hi, Paul-
I think I understand enough of your process; would it be possible to
set up a single tab in a single workbook to handle every person from
every team? This would effectively create a database-like table of
information that you could use to summarize data. For instance: you
could have dropdown columns for Team number, a dropdown column for Team
member name, a dropdown for project name, a start date column, an end
date column, etc.

This would solve you the aggro you're currently getting from changes to
cell references and definitely save space, for instance. It would
allow you to total and summarize data efficiently and effectively, and
the use of dropdowns would prevent data entry problems. You could sort
rows to group data by team and team member, if that would help.

That would be something of a sea-change in terms of the way you
currently maintain the data, but in the end it would be much more
efficient because you could run pivot tables to summarize the data.

Is this do-able?
Dave O