Sum the same cell across multiple sheets - variable number of sheets

[snb]

Don't split data into separate worksheets.
Use an intelligent table and a pivottable instead.