Need to find product codes and sum them as I add new reports.

Hi there,

So I am entering a set of data into a new sheet daily on a workbook. Each day, information regarding different codes (each process has a code) is entered.

I have a main sheet, where I would like to find a way to find all instances of that code in my workbook (for example: 004), then sum them on the main sheet.

This will help me identify how much of that code has been entered each month.

Thanks for the help.

EDIT: Example file - TestSheet.xlsx