hi

I have created a top level summary spreadsheet for accounts analysis that
adds all the values from the various tabs in the workbook (mainly using
vlookup). This works fine, but when next year comes, I would want to change
all the 08 to 09s on the tabs, but that would result in the vlookups not
working. I was thinking the best way for this was to reference the tab names
on 'data' workbook, and use this value in the vlookup formulae, but not sure
how that would work.
e.g. tabs currently called 'May 08 - Jul 08'
formulae in 'total' worksheet is
VLOOKUP($A5,'May 08 - Jul 09'!$A$4:$Q$130,16,FALSE)
and this formula has been used many times within this workbook.
So for nexts years spreadsheet, i would only want to change the tab names
(or a reference to it), and have all the formulae not affected.
At the moment I can change all the vlookup formulae as it will be a one
off, but dont want to have to do it every year - as i probably will not be
the one looking after it.
thanx