Search Engine using macros - how to create?

Hi

I am trying to create a search engine using macros, for a date where I would like to pull up data using a key word.

Its a contact data file and it would require to pull up contact number and location. It would also combine a list of worksheets in a single excel file.

Please help.

Thanks