How can I extend the series of a hyperlink

I need help.
I'm trying to figure out how to extend the series of a hyperlink from one cell down a column, and adopt or adjust the functions for its new row.

I've done this many times with formulas. I grab the corner of the cell and drag it down a column to extend the formula, and the formula adjusts to use data in it's new row.

When I try this with a hyperlink, it simply copies the link and points to the same location for each cell, instead of adjusting and pointing to the new location inteded.

How can I extend a series of hyperlinks down a row and have it adjust instead of simply copy?

What is the link that you are trying to adapt this to?

Originally Posted by Claymation

What is the link that you are trying to adapt this to?

I'm trying to create a hyperlink from one cell; say A3 to the same cell; A3 in a different worksheet.
This I can do, however I have hundred of cells I want to create hyperlinks to.
I could create a hyperlink individually for each cell, but I would hope there is a way to do this by creating one, and dragging the series down a row to expand it to each cell.
When I do this with formulas it works great. If however you try this with hyperlinks. All the links go to the same cell.
Meaning If I create a hyperlink in cell A2 in the first worksheet, then drag A2 down to A200, I expecting it to create hyperlinks from A2 to A200 in the second worksheet I point it to. My goal is to then be able to click any cell in the first worksheet from A2 to A200, lets say for example I click A50. It would then hyperlink me to A50 in the second worksheet.
What happens instead, is A50 hyperlinks to A2 on the second worksheet. It essentially copies the hyperlink, instead of extending it down like a formula would.
Any suggestions. I'm stuck.