Use some Absolute referencing and direct references to cells containing the search strings...

e.g. in C5:

=SUMIFS(S1T1!$E:$E,S1T1!$A:$A,$B$2,S1T1!$A:$A,$C$2,S1T1!$B:$B,C$4,S1T1!$C:$C,$B5)

you can copy formula across.

Then copy that row and paste to the other rows needing the formula... the references will self update.