Macro to edit hyperlinks in an active sheet of a multi-sheet excel spreadsheet.

I am looking for assistance in creating a macro that can edit specific hyperlinks in an active sheet of a multi-sheet excel spreadsheet. The version of Excel that I am using is Excel 2019 and I need the macro to only change specific hyperlinks. The criteria for the specific hyperlinks that I need to be changed is based on the sheet name. If you have the know-how to do this, please let me know and I can provide further details. Thank you for your time.