Linking a Hyperlink from another excel through function while preserving the hyperlink

Hello dear Users,
I am looking for a way to copy an existing hyperlink in another excel file, while preserving the hyperlink.

When i use =A1, the hyperlink does not preserve its hyperlink function.

Thank you for advice!

Best regards,
flashmonie