Syncing/sorting identical columns in 2 or more tables?

I have multiple tables which all share the same list in their left columns.

Please Login or Register  to view this content.

I frequently make changes to this left column and would like to make each change ONCE and have this change propogate to all the other tables automatically.

This is easy enough with =TABLE1[[#This Row],[Column1]]

BUT this solution is problematic when it comes to sorting data -- If I sort TABLE 1, the TABLE 2 left column will update to match it, but its corresponding rows of data won't move (since TABLE 2's left column isn't technically sorting, it's, just referencing cells blindly).

For example, if I re-sort Table 1 by name from Z to A, Table 2 ends up looking like:

Please Login or Register  to view this content.

Is it possible to sync ONE list between several tables in a way that allows each table to be sorted independently?

Thanks