You coulld save some time by changing your formula in C11 from this:

=SUMIF('relocation capture'!$E:$E,"Smith, Will",'relocation capture'!$G:$G)
to this:

=SUMIF('relocation capture'!$E:$E,$B11,'relocation capture'!$G:$G)
then just autofill down to complete the list in column C.

The same approach will work for the formulas in column D and E.