Hello Excel Forum!

I have a spreadsheet with data on multiple tabs. Each tab (Sheet1 through Sheet3 in the example, however my real worksheet has upwards of 50+ tabs) has a table of different length which has an attribute test on it. The table is summarized at the bottom of each sheet, and those summaries are always in the same column.

I am trying to pull in those sheet summary totals, and add them all together across the multiple sheets into one Summary tab.

I've tried 3d referencing inside of a vlookup, but that fails. Not sure what other path to take here.

I've attached an example workbook that has the summary tab and 3 sheets of 'data', so that you can kid of get an idea of what I am talking about visually. I'd like to be able to find a way to do this easily without having to manually add up each tab, or manually list out each vlookup indivudally. Test.xlsx

Thank you in advance for any help you can offer ... I really appreciate it!