Data from multiple sheets
I have 30+ sheets in my spreadsheet. I created the formula show below to lookup the data and add it all up in a "summary" sheet. Example below covers just two sheets of my 30+
This works and I get the result, but I am also hoping that there might be a way to reference all sheets without doing it one by one. Relevant data is in the same columns in each sheet.