Specific Alphanumerics initiates a find & replace function

Cell A1 will have a specific city name e.g. Troy, Celina, Piqua

If you look through columns C, G, K, O and T you will notice links that all come from the same file. Within the link is the name you will see in A1.

What I have found that works is a "find & replace".

All my links update correctly and everything appears ok.

What I would like to have happen is when I type the specific city in A1, it will automatically do a "find and replace" for whatever city I type in A1,thus updating all my links automatically.

I realize you might be thinking why not just edit the links to the file you want. The file I attached is small piece to a much larger workbook where the links are involved in numerous other worksheets within the workbook.

Hope this helps and thank you for your insights