VBA - Duplicate Entry Created when Updating Cell Contents

This version works fantastic for updating the sheet names and corrects the duplicate entry on the summary page, but the hyperlink breaks when the sheet name is updated.

Edited to add: In thinking more about this, it is probably because the sheet name is updating, so the original hyperlink does not have anything to refence to since the original sheet name was changed. If this is difficult to correct, we can make do with the original code additions you provided and operate understanding that any updates made to B5 will not update the sheet name. The only updates I can see occuring would be due to errors (typo, etc) on initial entry.