Hi Steve,

When you say "linked to the prior sheet" and "to the last
sheet", do you mean the worksheet immediately to the left of any
given worksheet? If so, what does the leftmost worksheet reference
and will new worksheets always be added to the far right position?
It's not clear how you determine just which worksheet is the prior
worksheet.

NOTE: If you click & drag the tab for worksheet 1 to the right of
worksheet 3 they will no longer be in number sequence. If that were
done, should worksheet 1 then reference worksheet 3?

I'll try to check back for your answers before pursuing this.

Best Regards,
Walt Weber