First post, thanks for this great tool, finally have come up with a question I can't find the answer by searching for on the site.

I'm trying to create a hyperlink from a cell in a workbook to another sheet in the same book that will display the contents of the linked cell. I've been able to get that far, but trying to autofill or copy the formula means I have to manually edit every single formula to move to the next cell down. Example of my goal/setup:

Sheet 1: Hyperlink that displays an individual's name (which is listed on Sheet 2)
=HYPERLINK("#'Sheet 2'!B4",'Sheet 2'!B4)
=HYPERLINK("#'Sheet 2'!B5",'Sheet 2'!B5)
=HYPERLINK("#'Sheet 2'!B6",'Sheet 2'!B6)

Sheet 2: List of names
Bob
Jim
Tom

The link location is what does not autofill correctly, the friendly name does automatically move down the column when dragged. Thanks in advance!

Shribbles