Hyperlinks

That is an issue with hyperlinks for sure.  Moving the linked file locations breaks the hyperlinks.  There are several options to explore.  If you have many links to update, I would play with the following options:

1 - if the linked files and the book with the links are all moving together to the new location, then use relative links instead of absolute links.  For example, if you have a workbook (let's call it the Summary book) that has links pointing to several files (the Detail files), and you move them all to a new location, then as long as relative to each other they maintain the same path then you'll be fine if you use relative links.  One way to set up a relative hyperlink is by using the =Hyperlink() worksheet function instead of by using the Insert > Hyperlink feature.  By using the =Hyperlink() function you can set up a relative path to the Detail files, and assuming the Summary and Detail files are all moved then the links will continue to work.

2 - if the linked files move independently of the book with the hyperlinks, then you have some options.  You could use a macro like the one below to update them all in bulk:
  Sub UpdateLinks()
    Dim URL As Hyperlink
    For Each URL In ActiveSheet.Hyperlinks
      URL.Address = Replace(URL.Address, "CURRENTPATH", "NEWPATH")
    Next
  End Sub

Don't forget to update the CURRENTPATH with your "old" existing path, and the NEWPATH with the new path.

3 - find replace.  You can't use Find/Replace unless your hyperlinks are actually created with the =Hyperlink() worksheet function.  Any hyperlinks that are created with the =Hyperlink() function can be updated with a Find/Replace (be sure to set the "look in" to "Formulas" in the Find/Replace dialog box)

4 - convert to formula, and specify the path in a cell.  You could convert the hyperlinks to the =Hyperlink()  worksheet function, and then you could place the path in a cell and use the concatenate function to prepend the path to the file name.  Then, at will, you could enter the new path in your cell and the =Hyperlink() formulas will update immediately.

Well my friend, those are 4 ways I know how to address that issue, and there are perhaps many more.  Hopefully though, one of these will get you where you need to be...good luck.