Hello everyone,

I am hoping folks here will be able to help me with this one. Here is what I am trying to do:

I have 1 worksheet with 11 tabs.
10 tabs are basically status report of 10 project managers - all using same format
(it is a project status report with 1 project in each row and each column containing project details for e.g. Priority, Urgency, Status etc.
11th sheet is topline summary report of the 10 project managers
I am trying to populate the data for this 11th sheet.
I have to use 2 criteria from Sheet # 1-10
1) Pull all data for the project that has Urgency ( one of the columns in the 10 reports) of A (out of A,B,C)
2) Pull all data that has business priority of 1 or 2 ( out of 1,2,3 & 4)

So my 11th sheet should carry all projects in rows that meet the above criteria.

Can someone please guide me on this ? Any help will be greatly appreciated.

Thank you,

Kashyshi