Summing Numbers With Specific Values To The Left Of Them

Im pretty new with Excel (only started using it since I got this job a few months ago) and I am sort of finding this confusing. If someone could take a look at my attached spreadsheet and mabye do it for me (if its not to much work) then tell me how they did it or show me how i can just copy those results. Thanks in advanced. Oh and the final product goes on a new sheet at the end.

EDIT - Just to let you know Plan Type B and two Benefit Code columns are the "items", Card # is not needed, and QTY is how much of the items were made. And as you can see that not all items are in the same spot on all the sheets. Colums A, B, & C are 1 list. D, E & F is another, aswell as G, H and I (3 Lists Side By Side). Thanks!

EDIT - Ignore this attachment. Correct one is a few posts down.