Address Book

Good Morning, I'm not sure if this can be done. Seems like Excel can do everything, not sure on this one. Here is a example of what I want too do, just not sure of the best way. Their are a lot of smart helpfull people here that will know if it can be done. Maybe their is a better way to do this, I'm open too all suggestions. It would be nice too have a master address book too choose from, something easy too input addresses too. I would like too keep everything in one workbook.
Thanks Again for all your help