I have a spreadsheet with about 600 tabs and have to pull data from multiple tabs into a single sheet. The information I need is not on the same line/cell in each tab.
I have attached a sample sheet with individual tabs and what the resulting tab should look like. Is there a formula or function that would do this easily or only a VBA code would work. Vlookup will not work since I have to pull the data from multiple tabs. I have to pull this data from 3 such spreadsheets and each spreadsheet has between 450-600 tabs.