Auto increment date in formula based on another cell

[GARTHMAN]

I have a workbook with a separate tab for each date a deposit is made. The following formula is used to pull info from "Daily Master.xmls":

='[APR 02, 2013.xlsm]Deposit Recon'!$E$6

I have about 50 formulas similar to this on every tab.

Is there a way to automatically change the formula on the successive tabs so that it will increment the formulas as follows

='[APR 03, 2013.xlsm]Deposit Recon'!$E$6
='[APR 04, 2013.xlsm]Deposit Recon'!$E$6
='[APR 05, 2013.xlsm]Deposit Recon'!$E$6
='[APR 06, 2013.xlsm]Deposit Recon'!$E$6 etc.

I would prefer to do this without VBA if anyone knows how to do that, but will use vba if it is the only option (for some reason VBA is frowned upon in this establishment and I will get my knucles rapped).Thanks for any insights you can provide.

 

[Jonmo1]

You can use INDIRECT for this.

But exactly HOW should we incriment the date?
Will you put the required date in a cell? Which Cell?
Should it just use Today's date in some way?

 

[Jonmo1]

Just to get things rolling

Let's assume that cell A1 contains the date April 03, 2013

You can use this to incriment it by one as the formula is pulled down.
=INDIRECT("'[" &TEXT($A$1+ROWS(A$1:A1)-1,"mmm dd, yyyy")&".xlsm]Deposit Recon'!$E$6")