Hi,
I have 1 tab, called 'Annual stats',within which there are 9 cells which
need formulas to add the values from the other 52 tabs (weeks). Each tab for
the weeks are the same, so cell E30 is for example one cell which I need to
be added. The tabs are labelled 'Week1' 'Week2' etc.

What formula could i use?