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