Lookups?

Download the workbook and see if this works for you. It assumes the row where TOTAL COMP is won't change. If it will let me now and I'll include that.
Formula looks like this:

Formula:

=SUMIF(INDIRECT("'"&$A4&" "&$B$1&"'!B2:MO2");B$3;INDIRECT("'"&$A4&" "&$B$1&"'!B8:MO8"))