Need VBA to create new Workbook and name it based on cell value in original file

Did you want a new file to be created each time you run the macro or do you want to copy the data to one file each time with the data added to the bottom of the existing data in the Input sheet?

Can you attach a copy of the template file? You can only change the name of the file when you save it. What is the full path to the folder where you want to save the new file? Is the template file in the same folder?

I assume you want to copy the data from the "Outputs" sheet in Sched_Example to the "Input" sheet of the template starting in column P. If that is correct, the setup of the 2 sheets is different in that the "Input" sheet of the template has formulas in rows 6, 10 and 11. If we simply copy the data from the "Outputs" sheet in Sched_Example to the "Input" sheet of the template, the formulas will be overwritten. Could you please clarify in detail which rows of data you want to copy from the "Outputs" sheet and exactly where in the "Input" sheet you want to paste that data.

Place this macro in a standard module in the Sched_Example workbook and run it from there.

Sub CopyDataAndSave()
    Application.ScreenUpdating = False
    Dim desWB As Workbook, desWS As Worksheet, srcWS As Worksheet
    Set srcWS = ThisWorkbook.Sheets("Outputs")
    Set desWB = Workbooks.Open(Environ("userprofile") & "\Desktop\Upwork\Model_Template.xlsx")
    Set desWS = Sheets("Input")
    With srcWS
        .Range("B12:M13").Copy desWS.Range("Q4")
        .Range("B14:M15 ").Copy desWS.Range("Q8")
    End With
    ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.Path & Application.PathSeparator & srcWS.Range("A3").Value & ".xlsx", FileFormat:=51
    Application.ScreenUpdating = True
End Sub