Help with SUMPRODUCT / INDIRECT

Hello, I have a screenshot here of a sum of ranges I am trying to do. In each of the tabs in the worksheet are tables with the same column headings the main sheet.

I defined L2:L6 as the name range to pick up from the other 5 worksheets of data. So basically I want to match the person's ID to their total in each term, and then use a SUM formula in column H to get their total for the year. I keep getting a #REF error and cannot figure out why.

What am I doing wrong? Perhaps my formula is too complicated for what I want?

Problem.PNG

=SUMPRODUCT(SUMIF(INDIRECT("’"&Sources&"'!A2:A72"),A3,INDIRECT("’"&Sources&'"!F2:F72")))