lookups for seperate workbooks matching date

[ammartino44]

Hello. I have workbooks based on the date. Here is an example "Daily Numbers Report - Summary_2014_02-18-06-02-30"
All of the files are formatted this way. Then, in a master file I have dates going horizontally for the entire year in the following format Tue Jan 15, etc. How could I do a lookup that would grab from all of the open files and match the date BUT subtract 1 day from that date for all the lookups, so Feb 18 would look at 2-17? Thanks.

[ammartino44]

Hello. I've added an excel sheet of the master file. Hopefully this helps.

[ammartino44]

Cmooooon!! This should be an easy one for you excel experts out there

[ammartino44]

Nobody?

[vlady]

maybe you should re-upload a workbook containing the expected outcome and the given data. 115 views is a large audience,

[ammartino44]

Ok. I added the master sheet where I want the formulas. I will have a lot of files open with exactly the same format. "Daily Numbers Report - Summary_2014_02-18" Then in the master file, in row 4, I have dates. I want a formula that will look at these dates, subtract 1 day, and lookup the values from the corresponding open sheet (I will have 10-20 files open at a time). The formatting for all the open sheets will be the same, that is the lookups and values will always be in the same cells. For the sheets that I've uploaded, Daily Numbers Report - Summary_2014-01-26 and Summary Sheet...the summary sheet will lookup the values and place them below January 25th (one day before the date on the open file). Please help with a formula. Thanks.