All of the hyperlinks I try and make linking to different sheets in my excel document will link to the same sheet, regardless of where I manually set the link location to be. Meaning if I have one link set to Sheet 2 and another set to Sheet 3, they will both link to only Sheet 2.
Solved by B. L. in 18 mins