Index and Match with based on IF then condition?

I am unsure how best to explain my problem, so I included an attachment with example data and my desired output, along with my first attempt.

I am trying to create summary tabs based on columns and rows in another worksheet. This is an example- in practice the "Rev" document in the attached is a complex pivot table based on inputs from company stakeholders. My desired output and my attempt (using Index and Match functions) is attached.

I need a solution that only includes Briefs if Rev>0 in the 'In Brief' column, instead of returning all the Briefs. Do I need to incorporate and Offset function?

I appreciate your input.

Couldn't you just create another pivot table off the same input data as the Rev table, and then filter for Rev > 0?

Unfortunately not. My pivot table contains many other pieces of information that make it necessary to keep the data in this format. I could augment the original data and create multiple pivot tables to accommodate my different criteria, but I am looking for a solution that I will be able to refresh weekly.

Sure thing. A ton of formulas go into getting the data so but I pasted it as values here to make things simple (I am unable to change the format). Data -> Pivot -> Pivot Values (paste as values, clean, sort) -> 'Aviation' tab (Desired Output).

I am open to any suggestions you have to make this easier. Thanks for taking a look!