I have been trying to figure out how to copy a hyperlink formula to another spreadsheet and cannot find an easy way to do this.

Basically this is what I am doing. I pull a report that contains a hyperlink formula to a website and every day this report has 50-100 new hyperlinks. I want to copy this hopefully with a formula to a master spreadsheet that I am using. Is there anyway to do that while maintaining the clickable link to the website? I have used a simple VBA function, I have tried some formulas but have not been able to get anything to work except of course manually doing this.

Any suggestions?

Mike