Creating an advanced search/find function

I am trying create an advanced search function in Excel. I don't know if this is even possible. I have a spreadsheet with 30-40 tabs. On a daily basis, users need to search for account numbers or client names. For any given account/name, each may show up in one tab or multiple tabs.

I have tried using the "find" function in excel, but it is only limited to one tab at a time (I know if you select all tabs, excel will search all, but some of the users of spreadsheet are not savy enough to use this and I don't want to go this route)

There are two ways I am trying: I prefer option 1.

Option 1: create a function similar to what Excel has for searching key words in a document but expand to look at multiple tabs.

Option 2: create a message box that would ask the user "Enter search criteria." Macro would then search and return results in same box. For example if search for word "Smith", macro would display message such as: "Smith found in: tab05, tab12, tab22, tab48".

Thanks for the link but not quite what I am looking for. I don't want to create an additional sheet that displays the information. Also, the example in the thread attached is only for "exact" matches. I need it to work for "partial" matches. For example: search for any 5-digit zip code that begins with "100".

The marco would start the search with tab01. If "100" is found in tab01 then that cell would be highlighted. If the use wishes to continue then user would click on next. Macro would then search in tab02, then tab03, then tab04, and so on until last tab is reached.

I want the Macro to work just like the find function in Excel (or Adobe).

I have tried using the "find" function in excel, but it is only limited to one tab at a time

That's not true. In the Find dialog, click Options, then in the Within drop-down, select Workbook, then click Find All.

I can't use the find all function as per previous thread as our company is using Excel 2000 and it is not available.