I have a workbook that has several sheets. On one of the sheets I have
named several ranges of cells and formulae in other sheets refer to these
ranges.

Each week I need to 'archive' the sheet which has the named ranges, ie; by
simply copying it and re-naming it so that I can refer back to it should the
need arise. The 'original' sheet is then updated throughout the week.

When copying the sheet and moving it to another position in the workbook,
the named ranges seem to change to refer to the copied sheet, even though it
has been re-named. I don't want this to happen - I simply need the named
ranges to refer to the original sheet, the name of which doesn't change week
by week.

Any guidance would be gratefully received!