Need a batch file or VBA code to copy and rename a set of workbooks

Please can someone help me produce a batch file or VBA module for automated copying and renaming?

I have a project that I've been working on in work, and it's in the testing process. There will be some feedback coming my way soon, and I'll have to make some small changes.

In each office folder (of which there are 12), I have 7 workbooks. Each office's folder contains the same set of workbook files. The VBA code is the same in every copy of each workbook, so it relies on the filenames being the same as the folder name.

So for example, in the "LIL LIVERPOOL LEGAL" folder there are these files:

1 - TUE - TRANSFERS IN - LIL LIVERPOOL LEGAL.xlsm
2 - WED - TRANSFERS IN - LIL LIVERPOOL LEGAL.xlsm
3 - THU - TRANSFERS IN - LIL LIVERPOOL LEGAL.xlsm
4 - FRI - TRANSFERS IN - LIL LIVERPOOL LEGAL.xlsm
5 - MON - TRANSFERS IN - LIL LIVERPOOL LEGAL.xlsm
LIL LIVERPOOL LEGAL - TRANSFERS IN - WEEK SUMMARY.xlsm
LIL LIVERPOOL LEGAL - TRANSFERS OUT.xlsm

When I update these files (be it VBA code, or the workbook layout, or both), I then want to be able to copy this set of files to the other 11 folders. But of course, all the files need their names changing to the folder they are being copied to.

At home I have FileMenuTools, so I can copy the files to each folder, and then rename them all at once (not as fast as a batch file, but still faster than renaming them one by one!). But I can't install that at work.

So assuming I am prepared to specify the names of all of the folders when I want the files to be copied to (and then have their filenames changed based on the names above, and the containing folder), what batch file or VBA code would I need?

Edit: Thinking about it, although I would prefer a batch file, it may be better if I used VBA code, because my computer in work might complain if I try to run a batch file and it doesn't know what it is.

I'm guessing the best way would be to store the current folder name in a variable, and then once the files had been copied to the new folder, search for that old folder name in each file name, and replace it with the new folder name. And I could copy and paste the code for each folder, because it doesn't need to have loops etc to make the code more "convenient". But I don't know how to do that via a batch file or via VBA.

Never mind I'm on my way to doing it myself now. Feel free to delete thread