Auto change formula to include Tab name change

Hi,
I have a formula in a cell which reads =sum(sheet 2!A1+Sheet 3!A1)
Now, sheet 2 will change it's name to today's date after I run a report for work. Is there a way to auto change 'sheet 2' to datay's day in dd_mmm format? It's also important to have the _ in the name.

Thanks in advance
Stuart

Well, if sheet just changes name (you or macro or ... rename the sheet) this change will be reflected automatically in formula.

The other possibility is that you have the formula written one day, the day changes, and you would like to have it addressing new day (as a matter of fact - process data from another sheet).
In this case you shall give a closer look to INDIRECT function.