Sum of Named Ranges Across Sheets

[Val1100]

I have a cell with a named range called TEMP in each of the sheets in Sheets A thru E. These cells are found on different rows in each of the sheets. Is there a formula that will sum up (across the sheets) the amounts in all the cells named TEMP?

 

[westconn1]

there maybe an easier way, but this will work
=sum(a!temb,b!temp,c!temp,d!temp,E!temp)
i guess this will only work correctly if your names are defined for a sheet, if they are defined for the workbook it may return the same range for each sheet

 

[Val1100]

Thanks for your help. I was able to use your suggestion in the spreadsheet I was building. It worked just fine. Much Obliged.