There are only certain functions that work with 3D references.
SUMIF and SUMPRODUCT are not among them.
Search Help 3D for the list of allowed functions.
Your formulas can be simplified if you use defined names.
If you define Code ='001:013'!C24:C37 at InsertNameDefine
then INDIRECT("'"&TEXT(ROW(INDIRECT("1:13")),"000")&"'! $C$24:$C
$37")
reduces to Code
A small simplified example with inputs and desired outputs would help.