I have a question on how I could populate data using a combo box selection in Excel 2010.

For example,
I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.

Maybe to make it clearer...

Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998

Combo box (selection of names): John

Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998

Any help on how I could solve this would be greatly appreciated
Also, do let me know if this can be done without the use of VBA.