I'm trying to set up an excel spreadsheet that I put in addresses in one cell
essentially... and it populates more than one new datasource file (ultimately
this file is used to draw information for a macro to process later) and also
it puts these changing addresses into a running list in another excel file-
basically creating a file that lists all the properties I've worked on in the
last month. It's redundant to copy/paste these addresses and hopefully I
can do something that will populate this running list.

the static link to a specific cell -I can do already. the pull from a cell
and write it in a new cell below the last entry-that escapes me.