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.
Bookmarks