I have a workbook with two sheets. The first sheet has a list of about
20 items and a dialog box adjacent to them that enables the user to
select the item. The second sheet is a basic form template.

What I want to do is create a macro that looks at which dialog boxes
are selected and then creates copies of the second sheet for each item
selected and have the sheets named according to the item name.

Anyone know if this is possible or how to accomplish this? Any help
would be greatly appreciated!