Hello.

I'm trying to create links within one workbook to several hundred others.
I'd like to use the TEXT formula in my cell references (about 10 per
workbook) so that I can simply copy all of my workbook names to update the
cell references instead of using the REPLACE function on all of my links.

Basically I will be using a cell value as part of the name of a linked
workbook.

For example:

In Workbook_A:

Workbook_1 Link1 Link2 Link3 Link4 Link5
Workbook_2 Link1 Link2 Link3 Link4 Link5
....
Workbook_400 Link1 Link2 Link3 Link4 Link5