I think this is correct now. It seems a bit pointless having the two sheets though? And I assume the bottom table on Data2 where it just shows Name and # Assigned it just for display purposes and isn't meant to be in in any calculations, correct?

What I changed was that the formulas in Data2 were not being associated to the adjacent person's name so of course when sorting occured things would not match. Also, and this has no effect but just an FYI, your Data2 had formulas for Data!A2 instead of just A2, which usually highlights itself in blue in the formula itself you will notice on the original you uploaded.

Attached Files

SampleData_rev1.xls (26.5 KB, 15 views)