I'd like to insert the value of a cell in Excel worksheet A into the cell of another Excel workbook B. The twist is that the source file begins as a templated file and is copied into new jobs each time. The destination file location and name stays the same but the source file changes location. So the destination file can't be looking to be updated. What needs to happen is that once the source Excel file is copied into a new job, whenever the cell is updated, it needs to "export" the new value into the source file. Not the other way around as the destination file will not know the location of this new source file. Sorry for the confusing syntax but hope this is clear enough for an answer. Thanks.

Johnny