I am not sure what you want to do.

In case you want to add the cell A1 across many sheets then use this
=Sum(Sheet1:Sheet10!A1)

This will add up the cell A1 on each sheet which is between Sheet1 and
Sheet10. By 'between' I mean on the tabs at the bottom of the workbook. If
you have only two sheets the first one named Sheet1 and the second Sheet10
then it will add up only these two. Now if you insert many sheets in between
(names don't matter) then it will add up those too.
If you move one to the right of Sheet10 (or to the left of Sheet1) then that
sheet will not be added.

Lookup Consolidate in HLEP...

"seeker" wrote:

I have a spread sheet that I created to upscale and downscale food recipes. I
have linked an €œorder page€� to individual recipes so if I want to increase or
decrease the recipe I only have to enter the amount of cases I want to
produce and it flows to each sheet. The last page I have is an inventory
page. I have used the V-lookup formula so that each individual recipe looks
at the inventory page to get its price per pound. For example =VLOOKUP (B13,
Inventory, 11, FALSE)*E13. B13 is the name of an ingredient, then it looks
at the inventory page finds the exact ingredient, then looks 11 columns over
and uses that price per pound.
I am trying to create a page that will add up all the ingredients from each
individual recipe so I can use it to order ingredients. I have used the
following =VLOOKUP (B9,'Sweet Orange Chili Mustard'! B13:E18, 4, FALSE)
this works great for one sheet, but when I try to add another sheet either by
using a , or putting the additional sheets in a () it returns a N/A. Anybody
have any ideas.