I have a summary workbook that pulls information in from other workbooks.
Each workbook relates to one specific real estate property. So each of the
source workbooks is exactly the same, except for the values within the cells
within the workbook, but the format and headings are identical.

So in my summary document, I have the property addresses down the far left
column, then I put links to the specific cell within the source document
across the row. For example: \\computer\my files\123 main st\[123 main
st.xlsx]termsA1

It looks like this -

PROPERTY PRICE CLOSE DATE BUYER NAME
123 main st $200000 5/1/09 Smith
456 maple $100000 5/15/09 Jones


What I would like to do is just type in the property address into the left
column to start a new row, and the links will use that address to insert into
the path. So in my path example above, I would like to insert a cell
reference instead of the words "123 main st"

I'm using find and replace now, but was hoping for a more elegant solution.