SUMIF? -multiple worksheets, add all cells adjacent to cell w/ value matching query

I appreciate your help, I am having a little trouble however.

I installed morefunc, restarted excel, opened the exact copy of my workbook that I updated, pasted the THREED formula you provided into cell D4 on the "PULLS" page but I get a #REF! error, even if I drag the formula all the way down the pulls page. Please advise.

Thanks, NBVC! That sheet works great. I don't really know how it worked but I've been spending time playing with those functions, specifically "threed".

I have a question, with the exact same sheet as above. What I want to do now is run a total (same as what I have) but have it count the total if the quota is listed to go THAT day. On each quota sheet (B11:H11) is an X if the quota is filled that day. I need to draw, in the pulls sheet, a table that counts out the total packs sent out per day.. (function will sift through all sheets, and sum each pack on that sheet against all other packs on sheets going that day, providing a total on the pulls page per pack, per day)

What I want it to tell me is.. all the packs going out on each day of the week essentially. What I've tried to do is:

=SUMPRODUCT(--(THREED('ISLET - ISLET CLINIC:UOFA - CS-SPD BULK #1'!B11)=X),(THREED('ISLET - ISLET CLINIC:UOFA - CS-SPD BULK #1'!$E$19:$E$41)=C7),THREED('ISLET - ISLET CLINIC:UOFA - CS-SPD BULK #1'!$G$19:$G$41))

Which I think is way off base. I'm new to multi-sheet functions so it's a bit over my head - I really appreciate your help - I hate to seem like I'm asking someone to make this sheet for me.. I've been trying for the past week to tie it up. I've attached the new sheet with the aforementioned table.

Getting closer; bump