Hi everyone,

I'm having a lot of trouble getting this one to dance for me and really need some expert help.

Basically, what I would like to have happen is as follows:

1. User enters list of departments into column headers across Row 1 of 'Start' (labeled Worksheet Name)
2. User clicks button
3. Workbook automatically duplicates the 'Template' worksheet and renames each new sheet with a column header from 'Start' department (Step 1)
4. Per column, the workbook copies the Patient name from 'Start' (i.e. 'Start' B2) to E2 of the corresponding duplicated sheet (column header in 'Start' and worksheet name must be equal)
5. The workbook repeats step 4, copying the Department name (B3, C3, D3, etc.) to the corresponding duplicated sheet's E3
6. The workbook repeats step 4, copying all Charges from 'Start' and pasting them down column D starting at D7

All help is welcome and I'll be 100% here to answer any questions promptly! Worksheet is attached.
Copy of Charge Testing Tracker- FSC Improved with Macros Draft 6.xlsm