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.