I am setting up a new time sheet. I have created it so that the tab is labelled from a specific cell in the sheet and that the first date of the week references the previous weeks last date (i.e. ='30.07.12 Mon'B11+1). That's all working fine to a degree. When I was creating it I didn't realise that I had entered the incorrect date so all my dates were out. When I adjusted the date the sheets updated but the tabs didn't unless I manually went to each sheet and double clicked the (='30.07.12 Mon'B11+1) cell.

Can anybody shed some light on this and educate me on how to get my sheets to update automatically? I would really appreciate it.