Good afternoon forum members

First post here regarding a work assignment I currently have. To describe it quickly, we are keeping a master inventory of all the forms available to be used by the department in the first sheet, and then they are separated per program in the next sheet.

What I'm looking to do is link, for example, cell C3 (which includes a hyperlink to the actual form on the LAN) would be copied to cell C3 in the second sheet. Therefore, if theres a modification in the future, only the master would need to be updated (with the new name and links), the rest would simply follow.

Issue is, I can't seem to find the proper formula to keep the hyperlink 'clickable' in sheet 2, only the cell content moves over.

I doubt its hard to fix, but every search I've done wasn't clearly related to my issue..

Thanks for your help.

-Simon