Macro or Formula to search worksheets and return results base on criteria

[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]

Duplicate post. No workbook attached.