Hey everyone,

So first of all, I just joined and this is my first post, so please bear with me!

I have a folder of weekly excel reports that I want to analyze. I want this separate workbook, "the Master", to pull in cells based on the file name. I don't have any issue setting that up, but is there a way to set the filename based off of a calendar? Essentially I want it to fill columns from other excel files whose filename is a date in YYYY-MM-DD format, the day always being an increment of 7. Any helps, ideas, suggestions, or solutions are greatly appreciated.

Thanks a bunch in advance,
X