VBA Macro to Hyperlink Excel Cells to Picture in Public Drive

[AshC1126]

I have several spreadsheets with hundreds of hyperlinks to pics in one of the public drives. The links keep changing from where I originally set them to a roaming folder. It takes way more time than I have to keep manually entering the links to each cell when they change.

Is there a way to make a macro to do the links for me?

Each link should go to a specific folder inside another folder on the public drive.

Any help is much appreciated!!!