total and summarise data
 

Hello

I have 51 sheets in the same workbook.
The front sheet is a summary sheet of the 50 behind.
Each sheet has a list of codes with a value next to it, but the same code is
not on the same line in each sheet.
On the summary sheet I would like to add up all the values inline with a
specific code

What is the easiest way of doing this?

Thanks