Excel lists

I would like to create an external list which i can then use for a drop down list in a worksheet.

Pick from list is not what I want
Drop down list comes close

is there anything else

PS
If I am in a cell(A1) I want to select a list of name, email etc which i can then update that cell with.