If your filters are all single value filters.
You can achieve this by change all the filters to parameters.
From: use [field A] (string) as filter
To: create [parameter A] (string) , select list for "allowable values", "add from field" field A.
Then create a caculated field [flag] such as,
[field A]=[parameter A] (AND [field B]=[parameter B] AND....)
Then use [flag] to filter, true for the the first worksheet you mentioned, and false for the next worksheet.
But this is not feasible if your curren filters are multiple value ones.
Looking forward for better solutions.