I amaze myself at what I can't figure out. Anyways .. using excel 2000
3 worksheets in this document:
master roster sheet
attendance worksheet
running total worksheet

The Master Roster sheet has key columns linked to the attendance and running totals worksheet (lastname, firsname, IDnumber, etc).

Problem:
When I add a name to the master roster and re-sort the list, the names re-sort on the Attendance and running total worksheets (as they should) but the data attached to the name does not move with the name. End result: if we sort, the names change but the data is now connected to the wrong person.

How do I stop that from happening?

Thank you. Your help in the past has been invaluable.