Row wont lock on sort from linked column on another sheet

Good morning,

This is my first post, and I have searched the forum pretty well.

The two sheets in question are ‘Employee Totals’ and ‘PP19’

The column “Name” in PP19 is linked to the column “Name” on Employee Totals via
='Employee Totals'!B5

My question is, if I sort Name on Employee Totals, it sorts Name of PP19. However, the row associated with the sort does not change. So if I have data on PP19 for Test 1, if I sort, the data stays with the row but Test 1 will move to the appropriate sort without the associated data.

Question 1: How can I lock the row to move with the sort?

Question 2: With regards to filters, I understand how to manually select filters, but how can I pass the value of a filter from a drop down box as included in the Search By box on PP19? Would it require VBA?

Thank you in advance.

Side note: I dont want to use a table because I plan on sharing this among multiple users on a shared network to be updated at the same time.