I have two spreadsheet in one workbook. The first spreadsheet is the cover of the whole file. The second spreadsheet is a database that is updated weekly. A part of the first spreadsheet has hyperlinks referencing to the second spreadsheet. What I use for the hyperlinks is the Name Manager that has names within the database. My issue is, the database is updated and has added information which is then sorted so the cells gets pushed down. I have to constantly update the reference cell of all the names in the name manager. Is there a way so that I don't always have to update the name manager or maybe another way that i'm not seeing.