Totalling/consolidating data

[GLewis14]

hi all,

Hopefully a very easy question, I am trying to total together a list of paired/connected data sets and create a new sheet (that will update automatically, when the original sheet is updated)
In the attached Excel, the product level sheet has two codes (see column A). I want to have the total quantities for these two codes, for the attributes in column J, in the same format in the Total sheet.
I have manually summed up what the answer should be in the total sheet to illustrate
Thanks, much appreciated
Gareth