I am questioning if it's possible to create a search box on sheet1 for example, type in a reference number then when clicking Search it takes you to the sheet that contains that reference number?

The reason for this is I am wanting to share some inventory data with our IT Service Desk and to allow them the ability to search and find the inventory stock at the click of the button is invaluable. I know the Find & Select feature already offers this but I'm looking for a sexier way of performing it.

Any thoughts?