I need to a search from "sheet1" I would like to be able to enter a search term that would be a sku number (16 digits) It needs to look in every sheet but only in Column H.

When it finds the item I need it to return the result in Column H.


For example.

Search MA00HH12345BU1FB

finds the result on sheet5 in cell B7

Now show the result as cell H7

I would need a reset button for the search field and result field too?

Many Thanks

Matt