I've created a template file that replicates most of what I need:

Dim strTemplate As String: strTemplate = "Path\template.xlsx"
Dim wb As Workbook

Set wb = Workbooks.Add(strTemplate)

This works perfectly but I am not sure how to then cut and land the data into the newly-created workbook. It also obvi doesn't change the file name as I described earlier.