Excel Document that creates new excel documents monthly

[Ajaxs87]

Hi,

I was trying to make an excel document that creates a new copy of document templates I have monthly. I have three attachments:
The first one (Monthly File Reset) has a few formulas to dictate how the file name should be written and the other two are more or less blank templates for reference for the process.

What I have envisioned.
- Cells B1 & C1 = are the now() function and will change month to month and year to year, respectively.
- A5 & A6 = Are the Filenames
- A12 & A13 are concatenate formulas of Filenames, b1 & c1

I am seeking to have a formula that when opened, looks at a folder location, and sees if the concatenate string name exist.
If it does exist, then nothing Else create a copy of the template and name it the concatenate string in that cell.

Thank you in advance for any help and please respond with questions if I didn't make something clear enough.

(My apologies I posted in General and not in Excel Programming / VBA / Macros)