Search entire workbook and display results

Hi, I am looking for help to achieve the following with an excel workbook:

- Add a search box/field/prompt where the user can enter a part number, and where that part number is found, display the entire row somewhere separate.
- The search function should search every sheet in the workbook, and display the results on a separate sheet.

The workbook consists of a list of part numbers and alternative part numbers, so the reason for this search would be for the user to enter any part number, and for the search result to show all related part numbers (entire row)

Is this even possible?

Thanks for any help at all or tips if this sounds like it is impossible?

Attached an example

Thank you HansDouwe and Jacc, both of these solutions work perfectly