sum across range of sheets for a cost code

[monkeydoom]

I'm trying to create a summary sheet at the end of a workbook that will
automatically total the amount spent from a specific cost code.

My first sheet is "template" and my last sheet is "Totals", cell O32
contains the total spent and cell H38 contains the cost code of each oder.
Each time an order is made, the template sheet is copied and renamed
according to vendor and date and placed in front of the "Totals" sheet.

I've tried:
=SUMIF(template:Totals!H38,"4960.114.44114",template:Totals!O32)

Does anyone have suggestions.

 

[Don Guillett]

Where you define a name ms= and modify as needed. Or make a list in a
column.
={"Sheet1","Sheet2","Sheet3"}

=SUMPRODUCT(SUMIF(INDIRECT(ms&"!h38"),"xx",INDIRECT(ms&"!o32")))