Macro DtRNG as Range, Dt as Range, Multiple Criteria or dates

It was actually what the code is meant to do I was wondering about.

Obviously you have a bunch of files you are opening copying from.

Where are those files located and where are you copying to?

Why do you need to change the date?

Are the files being generated on a daily basis?