Is there a way for me to use VLOOKUP (or another function) to be able to
compare records in one workbook with only one sheet (master workbook 1.xls)
to another workbook (slave workbook 1.xls) which has multiple worksheets
without cutting and pasting the multiple worksheets in the later all into one
sheet?

Thanks so much if you have an answer.

Jerry