I have files that are saved by the name of the report and the day of the week. Because of the weekend and holidays I can't have it overwrite.

I want a user form that the user put in (Tue) and all report that have Tue in the file name are moved to the (Tue) folder, or have the user pick (Tue) and setup a range in those files so the data can be put into a Master file (Master file Tue)

One range is name Route and Center Location