Creating and Save new workbook based on cell value

[shamim]

Hi,

I want to save new workbook based on cell value mentioned in "settings" sheet's column C.

Please see the output file. The new workbook should save into particular path mentioned in Data tab.

Brief description of Macro-

Step 1. Data tab has two tables Black and Yellow one.
Step 2. Data needs to be sorted based on Supervisor type.
Step 3. Paste data onto newly created workbook.
Step 4. Save output file with supervisor type name. ** VBA MACRO STOP WORKING HERE.

Can anyone help on this issue?

Regards,
Uday