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.