Data transfer between sheets?

Hi everyone. I need some help on my computer project. I am planning to make a card of membership for a fictional sports gym.

Here's the thing. I need information from this sheet:

http://img.photobucket.com/albums/v3...excelstuff.jpg

Come to this:

http://img.photobucket.com/albums/v3...xcelstuff2.jpg

Now, there is a simple way to do it, but I need to use a more impressive way. What I had in mind was to create a combo box which would allow me to select a member's name and the information of choice would automatically appear, but I have no idea how to do it. Each piece of information would go like this:

http://img.photobucket.com/albums/v3...xcelstuff3.jpg

So I really need help here.

If I want to get a good mark, it would be far better if I didn't have to input the data manually, that's why I'm posting here.

Is there a more efficient way to do it?

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

Simple VLOOKUP formulas are all you need. Why over-complicate it?

Use a data validation drop-down to select the name. See Help for Designate valid cell entries

If you're just looking to show you know how to do things various ways, then use VLOOKUP for some of it, then an INDEX/MATCH for other portions. Both significantly useful tools and showing you can use them should gain you points.

LOOKUP (data needs to be sorted to work properly)
VLOOKUP (data doesn't need to be sorted, but only returns answers to the right of searched range column)
INDEX/MATCH (data doesn't need to be sorted and results can come from left or right of matched column)