Need 1 worksheet to add totals from multiple worksheets in the same file.

OK now that's COOL!!!!  I had no idea you could use a wildcard in the sheet name.  I created sheet names: "Sheet1", "Sheet2", "3", "Sheet4", "5", "Sheet6"

and then typed =SUM('Sheet*'!A1:B1) and on Sheet1 it was changed to: =SUM(Sheet2!A1:B1,Sheet4!A1:B1,Sheet6!A1:B1)

don't know how I will use this but very cool!  Thx for sharing.