I am in Excel 2007.

This may be easier to explain if summarize what I am trying to accomplish. I
run a real estate office. I have created a workbook with over 100 fields to
track individual property transactions. Each workbook is the same format, but
with different property detaills, and will be saved with the property address
in the file name. Then I have a created a separate master summary workbook
that pulls out key bits of info on each transaction. This will give me a
snapshot look at all our transactions.

I have no problem linking from the multiple worksheets back to the summary
document.

Here is my challenge: When I start a new property workbook, I'd like to find
a way to automatically have some key fields populate and link on the summary
document.

Here is one idea I had. After I create and save the new property workbook, I
open the master summary document and type in the address, or the link of
where the new workbook is saved, and then somehow the next available row
populates with the info from the file named with that address from the other
workbook.

Any suggestions or other ideas would be most appreciated! If this has
already been addressed on these boards, please let me know. I searched for it
but couldn't find it.

Brian