Is this possible????
 

Ok I'm in need of a huge formula and favor. I need a formula that will
search out across 36 extrenal wook sheets find the right 3 matching criteria,
then Grab the Lot number and the amount used of that lot and place it into
another time sheet. There are 11 cells where Lot numbers can be entered and
11 cells right next to the lots for the amount used. Then it has to pull the
right numbers( lots & amount used) to the next sheet. This is a very active
sheet and im using '07 to program cells. Please tell me if this is possible
then ill post the ranges and locations and such.