Links to cells within worksheet carry over when sheet copied and do not link to old sheet

Hi Excel Forum,

I have a worsheet that at the top has links to certain cells within the sheet.

For example if someone clicks on the November hyperlink in Sheet 1 it takes them to the cells that contain November data, i was wondering if it was possible to make these links somewhat dynamic so say if sheet 1 is copied to make sheet 1 copy the links do not link back to the previous sheet (Sheet 1) that is copied but stay on the newly made sheet (Sheet 1 Copy).

when i copy the sheet at the moment when i click on the November link at the top of the newly copied sheet it takes me to the data on Sheet 1 for November not on Sheet 1 Copy.

I hope this makes sense.

I look forward to your responses.

Jamidd