Compound if statement?

[graphpak]

Here is my situation:

I am working with 3 worksheets...each worksheet represents a location of a warehouse. There are 2 columns in each worksheet, one an item# and the next a quantity. What I'm trying to do is create a formula or possibly a macro that would allow me to enter the item# and excel would lookup every instance of that item# at all 3 locations and then calculate a total number of pieces from the 3 locations. Can someone please help me with this formula! THANKS!!

I am having trouble with Aladin's suggestion...is anyone willing to enter this formula for me if I send you an email with my excel file attached to it?

 

[Todd Bardoni]

And naming the sheets using an array? Is that yours? I love it!

 

[Brian from Maui]

And naming the sheets using an array? Is that yours? I love it!

NOPE! Aladin all the way!