You can do this with a Pivot Table; in Step 1 specify Multiple Consolidation
Ranges
OR Google for Excel Consolidation to find add-ins (not free)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...
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