Search for a name into Multiple Tabs

Hi. I would like to accomplish a task. I know how to use a simple MATCH/INDEX function. But now I come across with multiple tabs. Example:

I would like to find all info regarding John Doe. But John Doe is sitting on one of those tabs (INFO1-INFO7). How do I search for him using MATCH/INDEX or perhaps by using other functions.

Notes:
- I would like to avoid highlighting the tabs and CRTL+F to find what I'm looking for.
- This worksheet has no duplicate name.

Please see clean attached file. Thank you very much in advance.