<tbody>
LEEDS
DRESS
=SUMIF(INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!C$12:C$25"),$C9,INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!J$12:J$25"))
DENIM
SHIRT
</tbody>
<tbody></tbody>
Where JAMIE SHEET LEEDS is the data source which has multiple worksheets.
The INDIRECT function is...