Update Connection String's IP address with cell content change

[jeff_cp]

I've got a spreadsheet consisting of several ODBC queries that I need to distribute to multiple individuals. The ODBC server's IP address in the Connection String will be different for each individual so I'm looking for a way to update the server's IP address based off of an IP address I enter in a cell on a worksheet in the workbook.

For example, if the server's IP address is 192.168.1.50, I want to be able to enter 192.168.1.50 in cell A2 on a worksheet called "IP" and have it update the connection information on each worksheet.

Is this possible?

 

[jeff_cp]

Forgot to add that I'm using Excel 2010.