I have workbooks that contain sheets names with consecutive month names -
like Jan07, Feb07 etc.

I have a cell containing running totals from previous sheets plus some
figures from the current sheet.

I want to copy and paste the formula onto a new sheet when I create one but
I want the sheet names to be updated to reflect the fact that I am using a
new sheet. So the old formula might be;

='Jan-07'!E21+'Feb-07'!C18

and I want the new formula to be

='Feb-07'!E21+'Mar-07'!C18

Is it possible to do this using Excel 2002 (from Office XP)

Would it also be possible for me to get the new sheet added automatically
ready filled in and named correctly using a Macro or Visual Basic ?

Any help much appreciated.

Thanks