Ensure/maintain connection/association between cells

[bobsone1]

Hi
Is there a way to permanently maintain a link between 2 (or more) cells.
In the attached file there is a table with "Name" and associate "Criteria" and a separate "Totals" table which (in my work book) would be updated on an ongoing basis.

My problem is that because a persons "Totals" cell value contributes to a yearly data set I want to be able to maintain the "Totals" for each person even if they are no longer (have been removed from) the "Name" list.

Ideally, I would like to be able to automatically move any "have been removed" names to an area below the main "Name" etc table.



Regards.