On the opening of an excel file with a number of worksheets named as
follows:

FDC
Packs
Covers

I would like the following to occur:

1. A selection list of the current worksheet names (these may
change so I want this to be dynamic) to be displayed in some kind of
message box (radio buttons, listbox,any method would do).

2. On selecting one of these and pressing OK, a Microsoft file
selection window will be displayed ( this is to allow me to pick up a
file of raw data from a folder)

3. When a file is selected and OK is pressed, the sheet selected
will become the selected sheet and I will then perform some sheet
specific code using the raw data to build a report in this worksheet.
I realis this aspect will need to be hardcoded as I will need to
recognise the worksheet selected via VBA code to run the correct code.

I would love any help on this, including any simple example code that
I can tailor.

Thanks

Mark