Create new workbook named for Cell in original workbook and copy some sheets from original

… as a starter :

PHP Code: 

Sub Demo()
        Dim Ws As Worksheet
        Application.ScreenUpdating = False
        Worksheets([{"NEW MASTER ORDER FORM","Item Qty Pivot","Employee Deduction Pivot"}]).Copy
    With ActiveWorkbook
        For Each Ws In .Worksheets
            With Ws.UsedRange
                .Formula = .Value
            End With
        Next
            .SaveAs ThisWorkbook.Path & Application.PathSeparator & .Sheets("NEW MASTER ORDER FORM").[F2].Text
    End With
        Application.ScreenUpdating = True
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !