I have multiple worksheets with lists of parts and quantities attached to
them. Many of the worksheets have the same parts on them, is there a way to
create a worksheet with consolidated quantities for each part? I'm
thinking this will be a complicated formula, because the parts are not always
in the same row (but they are in the same column). Something like,
=(IFA1="JANTX1N622S",THENA2) for each part, where A2 is the quantity and A1
is the part? But then I need to total all the A2's over all the worksheets.

TIA
Scott