If you have a macro that does automatic sort at the beginning, you could add
one line that removes existing filtering (ActiveSheet.ShowAllData).

If you absolutely want a separate sheet for each Supervisor, then select all
these sheets together (click on the first one, then press Shift key, then
click on the last one while shift key is still pressed), then put in cell A1:
=SheetMaster!A1, then extend the formula to the whole range (add plenty of
blank rows at the bottom, so future additions in the master table will also
appear on individual sheets. Now select the master sheet in order to
deselect all the other sheets, then go to each sheet and use Data Filter
Autofilter and pre-select the Supervisor name.

Stephane.