Rename files and store them at different paths.

Hello.

Does anyone know the coding or if it is possible to make a code which renames files and store them in different paths?

Example:

I want the file EXCELtestYYYYDDMM.txt to be named only testYYYYDD-1MM.txt.
The original file will have the date of today, but the renamed file will have yesterdays date, except on mondays (then it would have to be the last friday).

And then stored in a different path than the original one.

The files would be *.txt *.pos and *.sen

Thanks in advance.

You are good!

If possible, are you able to do some adjustments?
- I want to keep the original file.
- I only want the macro to do the file made today. So that I can keep the older files in the same folder.

And a separate macro which copies these files onto different locations.

Thank you so much. It will help me a lot

And now it also changes any file in the folder with a date format, I would like to have it change only the files with a certain start like:
PERFEECTtestYYYYDDMM.txt to testYYYYDDMM.txt

And if you could be so kind to design a third macro as well:

This macro should be able to take the generated *.txt files and melt them into one textfile with a new name.

So that

test1YYYYDDMM.txt
test2YYYYDDMM.txt
test3YYYYDDMM.txt

becomes

finalYYYYDDMM.txt

and the date on the test files should be yesterdays date except on mondays (then the last friday).

Do you know how to fix this? The dateformat on the text files needs to be:
YYMMDD,

and on pos and sen: YYYYMMDD

How can I juggle between the formats?

Thank you!