Workbook Searching

Hi,

I am looking to create a workbook in excel, the workbook will have several work sheets each relating to a specific customer with part number information. I would like to add a front worksheet to act as a "home screen" and contain a search bar which will allow the user to input a part number hit enter and jump to that entry within the workbook.

Could anyone help me understand how I can achieve this or point me in the direction of a tutorial which might help?

Thanks in advance!