I want to create a summary sheet that will lookup a particular cells value on
multiple sheets (averaging 58 sheets) in a workbook (e.g. $J$19) based upon a
cell next to it ($I$19) that will match the criteria on the summary sheet
(e.g. w1, w2, w3).
I have tried VLOOKAllSheets but when there are other similar workbooks open,
it doesn't work right.
Anyone? I appreciate your help.