Locking column entries to an adjacent linked column

Workbook w/3 worksheets. Master Roster, Annual Dues, and Dance Fees. The
Name column of Master is linked to the Name column of the other 2 worksheets.
The Dues and Fees worksheets have a Dues and Fees column adjacent to the
Name column - entries there are tied to that name. When entering a new name
on the Master sheet, sorting alphabetically causes the Dues and Fees columns
to be off by one row below the new name after the sort. Is there a way to
lock the Dues and Fees columns to the Name column entry so this does not
happen? Thanks from a newbie!

If it were up to me, I'd put all the information on a single sheet and
sort that. If you need separate Dues and Fees tables for reports or
whatnow, refer from those sheets to the main sheet for the needed
information.

For instance, if on the Master Roster sheet you have your Names in
column A and Dues in column H, then your Dues sheet column B could
refer to the Master Roster sheet column H. In Dues!B1 you would have:

='Master Roster'!H1

and copy that down as far as you need.