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

Good Day Experts

I need a bit of help with my code please.

I have a workbook that will serve as a master workbook which i need to have a button in that the user can press to create a new workbook with name based on

Please Login or Register  to view this content.

Please Login or Register  to view this content.

needs to be created in the new workbook with all data from the original workbook in, but formulas removed.

The code i have below(modified from code found on the web....thanks to the original creator if you see this ), does all that, but the sheets created in the new workbook comes out blank. What am i missing?

Please Login or Register  to view this content.

… 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 » !

Works like a bomb.

Thank you very much Mark.

Originally Posted by ANDREAAS

Thank you very much Marc.

Thanks for the rep' !

thank you...very helpful