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
To the best of my knowledge filters work only for one sheet. What you can do depends on what you want to achieve.