engaging filter option in multple tabs
 

What is the best way to engage a filter to the value '1' in all tabs of a
large spreadsheet? The filter itself is specified in cell A1 of each tab of
the spreadsheet except the first tab which has no filter at all.
--
regards
Frank