I have a cell in my worksheet which links to the previous worksheet. i.e I'm
in Nov 08 and the cell looks at a cell in Oct 08 sheet.

Whenever I copy this sheet to create the next month, I have to update the
link to the previous month's sheet. =Oct 08!A4 must be changed to Nov 08!A4.

Can I create a formula which will do =[cell one to the left]!A4?

Thanks

Maria :)