I have a spreadsheet which has two worksheets, the first represents 6
months Jan to June and the second July to December. Each worksheet
has the same data in the first three columns (first name, surname,
teamname) I have autofilter set up to allow the user to filter either
their own record (by surname) or by their team. Unfortunately they
have to select this in each worksheet

Is there a way that the autofilter selected in worksheet one can be
automatically applied to worksheet two (and vice versa)