I'm making a tracker for my HSA expenses. I have it organized by year, one sheet per year. Within each year I have a "Purchases" table for individual expenditures and a "Totals" table for contributions, purchases, and reimbursements. I would like to have an overall sheet for lifetime totals. This sheet would sum together all the information from the "Totals" tables in each sheet.
Like the poster in this old Apple Discussions thread, I thought it would be nice if there was a "wildcard" function so that I can say: Sum this cell in all sheets. He put it like this:
=SUM('Sheet*'::Table_A::January Taxes). (Obviously I can manually add sheets/cells to the sum function, that's not what I'm asking.)
Apparently this can be done for a range of sheets in Excel, see here.