Hyperlink Formula
 

I have 300 different sheets on one workbook and they all go to a seperate
worksheet diferent parts of it. Instead of hyperlinking one specific one at
ta time, after I do one is there anyway I can copy them and they will update
automatically they are all the same distance apart on each sheet. Example,
g30 then g60. THey are like 40 cells apart.