I have the hyperlink "blah.xlsx" in cell Sheet1A1. I want to create the same hyperlink in Sheet2A1 automatically using a macro.

So everytime a create a hyperlink in Sheet1 Column A... there will be an identical hyperlink in Sheet2 Column A.