HELP! Pulling Data from Multiple Sheets into Cover Sheet

All,

I have a file that catalogs fire alarm devices in multiple buildings by and ID number( in one column) and status ((either incomplete, complete, etc.) in another column). Each building has its own tab that is formatted just like the rest. I am trying to make a cover page for this file that pulls all incomplete devices into a list and all complete devices into a list, both of which would show up on the cover page. The cover list would include (or transpose) information from 3-4 columns based on the status of one of those columns. I have coded all complete items as a status of "A" and all incomplete items as a status of "B".

The idea is that if a device changes its status from incomplete to complete on a certain tab, then the Cover list of incomplete devices shrinks and the list of complete devices grows.


Can anyone help me?

I have attached the file titled "Demo Device Matrix" if this helps. For further clarification, I basically need the white colored cells on each building tab to transfer to the cover page based on the Action status "A" for complete or "B" for incomplete. - This will make sense once you open the file.

AMAZING! Thank you for your help!