I need to create a workbook with 30 sheets. At the top of each sheet
there will be a dropdown box with 4 choices representing an existing
excel spreadsheet. Based on the user's selection in the dropdown box,
the existing sheet needs to be copied onto the new workbook sheet.

This new sheet will then be completed and saved in the new workbook
file without updating the fields in the master sheets.

How can I do this?