I have a report with this information:

Part Part Description New Buy RV Net Repair

The report is 4 worksheet long. I need a formula that looks thru the 4
worksheets and finds the information for any part # I type.