Sorted. Thanks for that.

"Ed Ferrero" wrote:

Hi captain,

Lets say
cell A1 contains the sheet name
cell A2 contains the row no
cell A3 contains the column no
of the cell you wish to find.

Then =ADDRESS(A2,A3,,,A1) will give you the cell address
and =INDIRECT(ADDRESS(A2,A3,,,A1)) will give
the contents of that cell.

Ed Ferrero

"captain stephen" <captain wrote in
message ...
Excel 2003. I produce a weekly cash report. Each new weekly report refers
to
several cells on the previous week's sheet. I produce each new sheet by
copying the last one and changing its name. I then have to update the
formulas so that they look at the now previous sheet. Is there some way to
enter the sheet tab name into a formula so that the name of the tab is
taken
from another cell.