I am trying to summarise multiple tabs onto one spreadsheet in a different
workbook that can have more than one row of data for the same criteria using
the following but it is returning with #REF as it is saying it is volatile.

$L$5 = Filename
$C10 = Tabname
$E$17:$E$28 = Range
$I$10 = Sumif Criteria
$I$17:$I$28 = Sum_Range

=SUMIF(INDIRECT("'["&$L$5&"]"&$C10&"'!$E$17:$E$28"),$I10,INDIRECT("'["&$L$5&"]"&$C10&"'!$I$17:$I$28"))

Any help greatly appreciated !