Consolidate 3 tabs into one tab with only 1 row for headers

So i need to consolidate three tabs into only one tab filtering all raw data tabs with "Day PL Review Pending" in Col BF and "Accounting Adjustments" in Column B

My problem is the Raw Data tabs rows differ every week and depends on the number of trades so there is no exact number of rows, just number of columns (A-DB). i try to record the macro but it doesn't go for all the tabs as i try CTRL+SHIFT+arrow key right but the blank columns differ with the tabs as well.

I need a macro that would copy all filtered tabs into the master tab.

Please help