Take the attached file for a test flight. I provided two solutions (User Interface on Sheet3). The search mechanism is the same in both using the Excel VBA 'Find' command. The difference is the first one ignores the first 3 sheets and the second one allows the user to select 3 sheet names to be ignored.
If you move the macro to your file, some of the following may have to be changed at the top of module 'ModSearchForItem'.
If you use the option that ignores the first 3 sheets:
If you use the option that ignores 3 specific sheet names: