creating a drop down list for names and addresses

wow, yes that is what I am trying to achieve!!! Please send me the instructions, my hero, ty ty ty!! LOL

So I can change font size....to make it fit in the spreadsheet? Also, can I have the fax number on its own line? And I know I am being picky, anyway to have a comma between city and state. I am doing this for one of my managers who doesn't have a clue on how to use excel and I want to be able to plug this into his existing sheet without making him redo it.

Out of curiosity, why isn't there a sheet 1?

Thank you so much for all of your help!!!!!