automate data entry by linking data

Please view the attached file. What I will describe is easier to understand if you view it. By the way, this is a simplified version of a larger problem I have. Although it may seem a bit trivial, your help here would be enormously beneficial to the big picture.

1.) On the worksheet called Data one should use this information to complete the worksheet entitled LinkDataHere.
2.) Needless to say, there are many countries in the world and one may not know where to enter a certain country on the LinkDataHere Worksheet. As a result, I created a map to clear up any confusion.
3.) What formulas/code could I insert into the worksheet called LinkInHere to automate this?