I'm assuming you're using V7 or earlier. Basic filters only filter one sheet. Global filters filter all sheets that share the same data source. So all you have to do is duplicate your data source, and then use one to create the 2 sheets you want to filter together, and the other to create the other two sheets.
If you're using V8 you have a menu option of applying the filter to 'selected worksheets'.