I have an Excel workbook that has 3 worksheets in it:
Parts1, Parts2, Parts3
The columns are:
Vendor, Part Number, Cost, Retail, Quantity, Location

I want a 4th. worksheet that I can enter a part number and it will search through the 3 worksheets and display the results in worksheet 4.
It is possible for their to be multiple results for the same Part Number, but not always. (For example, the same part number can be in multiple Bin Locations.)

I am a newbie at this, so detailed instructions would be appreciated.

I have tried using Vlookup, but it does not seem to do what I am looking for.