Thanks for the reply Pecoflyer
The paste values idea will help in moving a whole persons row.

My concern is that the way I currently have the tables organized it would be possible to change a name and have the new/moved name get the totals from another person.

This is why I had the idea of "somehow" linking a persons total to that persons name so when they are moved the total goes with them. Unfortunately, I have no idea of where to start to achieve this.

Is it possible to format some rows to only allow the insertion of new data and forbid the removal of any/all existing info? This solution would require the table to be filtered/organised each time a new name and criteria is added to the table, can excel be set to automatically filter a table?

Regards.