Multiple VLookup
 

How do I use the vlookup function (or else) to find data from 4 different
sheets? For example, I have a 5th sheet where I need to extract information
about a part # but the list is 4 sheets long. The part #'s are numeric and
alphanumeric.