Formula (or way) to update daily the name of report where cell is linked to.

I am uncertain the title of my post even begins to describe what I am asking and trying to achieve.

So I have a daily sales report which looks at some cells from the report created the previous date with formula below:
='F:\_Shared Files\Billing -Cust Serv\_Daily Report\[Daily Report 010713.xlsx]Totals'!$I$2

This report has been automated for the most part but this particular step is still manual.

What I'm looking for is for the bolded date in formula above to change automatically, I guess based on today's date, so that, for example, tomorrow's report will look at report dated 010813, and the day after at report dated 010913, etc.

Your assistance is already appreciated.

You would need to use the INDIRECT Function and that doesn't work on closed workbooks. You could use a Free add-in MoreFunc which has a function INDIRECT.EXT which does work on closed workbooks. Read about it and download from here.

http://www.ashishmathur.com/tag/morefunc/
Hope that helps.