Running Total of production by product ID

I would be obliged of some assistance could be provided to resolve the problem I'm having difficulty with. Daily records are maintained on batch production along with important batch code and shelf life detail.
I am looking to populate the total batch volumes produced by product on the separate worksheet, so that as batch data is inputted that new batch weight is added to the previous total, thereby keeping total volumes produced up to date.

I have attempted VLOOKUP formulas but to no avail, and any support would be greatly appreciated to identify the correct solution.

Many thanks

Phil