Syncing/sorting identical columns in 2 or more tables?

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

TABLE 1                    ......    TABLE 2

Ant  |  Row of Ant Data     .....     Ant  |  Row of Ant Data
Bat  |  Row of Bat Data     .....     Bat  |  Row of Bat Data
Cup  |  Row of Cup Data     .....     Cup  |  Row of Cup Data
Dog  |  Row of Dog Data     .....     Dog  |  Row of Dog Data

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:

TABLE 1                    ......    TABLE 2

Dog  |  Row of Dog Data     .....     Dog  |  Row of Ant Data
Cup  |  Row of Cup Data     .....     Cup  |  Row of Bat Data
Bat  |  Row of Bat Data     .....     Bat  |  Row of Cup Data
Ant  |  Row of Ant Data     .....     Ant  |  Row of Dog Data

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

Thanks