Sumif across multiple worksheets

[Ted Metro]

I have worksheets for every month of the year, each with employee names and
totals.

Is there a sumif variant I can use to go through these 12 worksheets?

Ted

 

[Ted Metro]

Just to clarify -- one file with multiple tabs.

 

[JE McGimpsey]

A couple of ways:

http://www.mcgimpsey.com/excel/threedsumif.html