How to filter data on different sheets simultaneously?

I'm looking for a solution to the following problem i'm facing:

I have an XLS file with a bunch of sheets containing data inside. Each sheet contains a table with data. The data in each table is used to calculate values in a seperate overview sheet within the same file.

Now, here is my question. Each of the tables in the sheets contains a column with an identifier and i would like to use this column to filter the data in the tables in all sheets simultaneuosly and have the data in the overview sheet re-calculated based on the applied filter.

Example:

Each table in each data sheet contains rows that have the identifier "A", but there are also rows of data with different identifiers.

The data in the overview sheet uses all rows of data as a calculation basis.

I want to apply a filter for identifier "A" through every table and have the overview sheet show calculated values for the filitered data only.

I tried searching for solutions, but haven't found anything feasible so far. Hope, you understood my problem and maybe someone knows an elegant solution. If needed, i can provide a sample set of data in the structure i've described.

Thanks a lot in advance!