Referencing data in a cell for a sumif formula pulling from that cells tab

[rcasey1227]

Have a different tab for each security setup. Trying to create a sumif formula with the criteria range pulling a tab name from a cell for that specific tab.
So for instance have the tab name Acala in cell E38, want the sumif to pull critieria from Acala!C:C, is there a way to make the formula pull Acala from cell E38 versus being typed in so can drag to other cells and formulate?
Please help

 

[jasonb75]

You would need to use the INDIRECT function for that.

INDIRECT($E$38&"!C:C") would return the range Acala!C:C