Reference a cell to another list of cells

Getting the wording correct on this question has been a little tricky which has made looking for a possible solution a little tricky as well. What I am trying to do seems pretty straight forward but perhaps just isn't something excel does. My small example is below

This is for a larger spreadsheet but can be shown with the example lists below:

North America
South America
Africa
Asia
Europe

Bob
Gary
Nancy
John

Ideally what I would like to happen is:

Double click on North America and open a new sheet that lists 'Bob', 'Gary', and 'Nancy' or conversely double click on 'John' and open a new sheet with 'Asia' and 'Africa'. To me that means I have told the 'North America' cell to keep the text 'North America' but link to two other cells when double clicked. Thus providing reference data behind the text 'North America' and vice versa.

Now for this small example I could add each country to each persons name. Once the lists get larger then adding manually seems more problematic and it would seem a per cell way of doing this would be better than adding all the data to each row or column and trying to sort it.

Any thoughts and/or help on this is appreciated. Thank you.

Thanks...let me digest and figure out the logistics of doing it this way.

I find it helps to give the original context of the problem as there might be a way to achieve the desired results that I didn't know about. What I have is a list of applications, database versions they are running on, hardware its running on, etc., on one sheet and a list of servers on another sheet. What I want to be able to do as documentation progresses is double click in a cell to show what servers support which applications. For each application there is a list what database version supports that application; I'd like to be able to double click that cell to view the database servers that support that application.

Not sure if that changes anything in terms of a solution. Thank you again for the assistance.