AutoFiltering Multiple Sheets?

There's a conference coming up and I have to track the Registration forms.

I have 4 sheets in an excel sheet. Sheet 1 has the Last and First name and contact information of registrants. Sheet 2-4 links to the Last and First Name Columns of Sheet 1 then continues with different information. (Sheet 2 is Meals and Room, Sheet 3 is financials, Sheet 4 is Workshops)

This is all well and fine, and I've linked cells in Financials to auto-tabulate their bill using information from Meals and Room. It's all rather cool!

However, it will eventually be that the Registrants in Sheet 1 will become overwhelming and confusing. I have an Auto-Filter set up in the top row to re-sort Sheet 1 by Last Name from time to time.

When I ask Auto-Filter to do this, then Sheet 1 properly re-orders itself by Last Name. The linked cells in sheets 2-4 also do this accordingly ... but not the rest of the information in these sheets.

Is there a way to link the rows in Sheets 2-4 to the Auto-Filter command in Sheet 1?