VBA - Saving different files from a template and raw separated data

I have a template file at its own folder where I copy data into from a bunch of perodic files from a different directory. The process I am attempting to automate is to copy data from first periodic file into the template, save the resulting feeded template naming it as the first data source file ("1" in the example) and then go back to the original empty template in order to loop the process with the rest of periodic files.

My clumsy attempt to this point has been the following:

I first copy data from "1" to "template":

Workbooks.Open fileName:= _
"C:\sample\template\template.xlsx"
Workbooks.Open fileName:= _
"C:\sample\1.xlsx"

Windows("1.xlsx").Activate
Range("A2").Select
Selection.Copy
Windows("template.xlsx").Activate
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Then I want to save "template" with the added data as "1.xlsx" but into the template folder:

Windows("1.xlsx").Activate
[[ActiveWorkbook.Name.Copy]]?????
Windows("template.xlsx").Activate
[[Saveas.Paste & ".xlsx"]]?????

Since I have no basic knowledge in programming but recording and cleaning up a couple of macro lines, I am really stucked into the "copy filename and save as pasting" steps. I assume there is a more efficient approach to the whole process but by now I just want to make the second part work if possible.

If you think I really need some basis before attempting stuff like that just give me the keywords to adress my learning.

Thanks in advance

Some suggestions you may find useful:

1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."

After discovering Name As and FileCopy I got the whole loop working for all files in the same directory:

Please Login or Register  to view this content.

Any suggestion to polish this procedure?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks