Fix Hyperlink Export Issue

I need a Google Apps Script/extensions expert to fix a Google Sheets extension issue where hyperlinks are missing in exports to Google Docs and PDFs. This issue started after adding two new classes and syncing their data.

Requirements:
- Find and fix the missing hyperlinks issue
- Ensure all other formatting remains intact

Ideal Skills:

- Expertise in Google Apps Script
- Experience with Google Sheets, Docs, and PDFs integration
- Problem-solving skills to debug and resolve issues quickly

Please share your past work and relevant experience.

Example which isn't export hyperlinks correctly -

https://docs.google.com/spreadsheets/d/1whJ1DSRQCU1rDSvytAVF7Znxkt1DhD7RwNf3HhFRNlQ/edit?usp=sharing

Example, before adding more tabs that are working,

https://docs.google.com/spreadsheets/d/1klP4aHA7vkihmiZ6jZd_-sIe7HsDnEzwuB1uew85698/edit?usp=sharing

The multi tab on the new version must continue to work.