hyperlink in reference cell

Thanks, it works but I bumped into a new problem.
The described case is for single cell, but I have a huge table to do that.
How can I multiply that cell with auto-increment cell position.
I mean if this written for A1 in spreadsheet A, and the hyperlink defined in cell A1 of spreadsheet B i want to define the rule by mouse dragging or any other automatic way for cells spreadsheet A cell A2 etc...

Thank you