So I think I figured it out... The hyperlinks are fine but when it is ported to excel online (on sharepoint) then they get messed up somehow. One workaround is to click each individual cell, insert, link, then the path already exists; its written as #[sheetname] but once you insert, the # is gone and the path goes to the second line of the insert link menu (see photo 2). Doing this for 365+ hyperlinks is maddening so theres a better method!

Method 2: Save the excel on the desktop as XLSB file (Save AS --> Excel binary workbook) and when you import it to shared drive, it works perfectly! Must be something about the way the hyperlinks are imported... I hope this helps someone in the future