VLookup from many sheets
 

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

The report is 4 sheets big full of inventory data (for example Part #=column
A and price=column B). I added a 5th sheet and I need to get inventory
information about any part # as soon as I type it in.