Create Drop Down Boxes Based On List

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................