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.

try it

Please Login or Register  to view this content.

Hi nilem. Thank you very much for your work and time. I really appreciated it. It worked but not the way I would like to accomplish. I just used John Doe and Jane Doe as an example. I would like to have a formula on column C, D, and E starting at Row 2 so when I fill up Column A and Column B with names, their corresponding info should appear beside them ( column C, D, and E). Please help. Thank you.