Reading files based on a formula...

Hi Xeronii and welcome to the forum,

My thinking is, this is a problem needing a Power Query solution. Power Query is a newer tool that Excel has as an Add-In. You can download it off the net to your 2010 version of Excel. It comes standard in 2016 Excel. Then you would use the Folder option in PQ and somehow select only the correct files. See:

http://excelunplugged.com/2015/02/10...n-power-query/

Generally speaking you should be able to pattern this using something like INDIRECT combined with other formulas. There are a number of ways to approach the increment. You could either hard code the start date in the formula or place the start date in a cell someplace, then simply start date + 7x, where x could be row number (starting from a reference to row 1). That would effectively add the n number of days to your start date needed and INDIRECT would be used to create the reference based on this.

As mentioned you may consider an option like Power Query and/or leverage a data model.

Another alternative would be a macro to simply gather data from all the files in a given folder.

Many ways you could handle it, hard to say whats best without more context.