Indirect lookup to diffent work book with a sumif

I would like the yellow highlighted cells to include an indirect formula to look up different work books from a drop down box (C2)

The drop down is with cell C2
C2 has two names which is the same as the two tab from which I would like to take the data from.

Can the indirect be added within my formulas ( formulas highlighted yellow )

Any help would be great

Thank you.