Sumif from multiple sheets

I am trying to sumif on a Totals Sheet in this workbook.

The problem I am having is that I am trying to calculate 4 different sheets to get to the total number.

Before the sheet was combined with all the reps on 1 sheet but it was much easier to sort and see by creating individual sheets.

I have attached the workbook with a couple of comments.

thanks for any help,

JJ