Macro or Formula to search specific worksheets and return results

[Shellybelly]

Anyone knows a formula or a macro that can search through an entire workbook and return results for a specific name? I've attached the workbook.

I will like for the macro to search the entire workbook for the name in the search field and return the schedules for the name.

The Macro or formula should only search the yellow, orange and purple tabs.


Any help will be greatly appreciated.

[JOHN H. DAVIS]

There is no attachment.

[Shellybelly]

Sorry see the attached workbook