libreoffice calc how link same data between different sheets and when use filter, to filter both linked sheets ?

[thanasis.info]

collum A is the same data for both sheets, when i filter data at one sheet i want to automaticaly filter it at the other sheet so i can use differet data from other collums from both sheets

[ROSt53]

To the best of my knowledge filters work only for one sheet. What you can do depends on what you want to achieve.