Creating drop down list from values in column

Hi

I wanted to be able to pick up the list of names of worksheets which are already in a column and rather than have a msgbox or inputbox, have a drop down list which the user chooses from, to select which sheet to delete.

Thanks for your help.
James