Macro to copy data from other workbook - let user choose which open workbook

Hi,

I'd put the list on the sheet in cells and then do a validation list from it.

I have no idea how your user interface works but validation lists are a lot easier than building userforms.