I have a set of 40 legacy workbooks, with at least two sheets per
workbook, that link between sheets and workbooks. To facilitate their
maintenance when new rows or columns are added, I am Naming Cells (i.e.
Named Ranges). What I am looking for help with is once I've named
Cells, updating all workbooks Link references to use the Name instead
of the sheet, row, column reference.

Does anyone have a good solution for automating changing these Links?