I am trying to create a table that extracts information from multiple spreadsheets in a single workbook. I have attached a sample for reference. Ideally I would like my table to look just like the one depicted in the "Smaller Table to Look Like" tab, however use formulas to generate the information. All of the other tabs are laid out and formatted exactly the same, but they represent different systems. Each tab is labeled by system name.
I only want information to be pulled if column B in the system tabs have an Implementation Status of either "Pending Validation: A1" or "Pending Validation: A2". Not all of the system tabs will have that Implementation Status (in the test workbook, tab "C_EX" does not). I would like the roll-up table to show which tab it is pulling from, associated Control Number from column A, Implementation Status from column B, and the Days PV from Column C.
Bookmarks