I have a workbook that has each sheet linked to the prior sheet. Now when I
add a new sheet, I need it to only look back to the last sheet.

Sheet 1 is named ABC
Sheet 2 is named LKJ
Sheet 3 is named PUY

I need sheet 3 to look back to sheet 2, and sheet 2 to look back to sheet 1.

This workbook will have over a hundred sheets in it before I create a new
workbook.

Therefore, when I want to create a new sheet 4, the links are not refreshing
to show coming from sheet 3, instead they show they are coming from sheet 2.

Any help would be appreciated.

Steve