Linking to CSV that doesn't exist yet.

[Rigged]

Hey Folks,

I have an AutoHotKey script running everyday that downloads a CSV file from a website. The naming convention is based on the current date 081313.csv, 081413.csv, 081513.csv etc. I have no problems setting up an INDEX/MATCH to grab the info I need from it, but I can't input the formula of a file that isn't created yet so I am stuck editing the formula everyday to reflect the most up to date values. I have the dates listed at the top so I was trying to setup an INDIRECT with no luck as well.

I have attached a file that hopefully explains what I am talking about.

Thanks!

Project File.xlsx

[Rigged]

After looking all over. I found INDIRECT.EXT but that doesn't seem to work either. I just need to have a column auto update the formula as the CSV files are created. Any ideas?