UM, can you even build code that will just DISPLAY all of the sheet names in a message box? If not, then this is way above your level, and we are not going to go into it like that. Post code that gets all of the sheet names first, then we will load an array into the selection drop down! Get it?
We don't do homework!