As suggested, I"m re-posting this from the General forum:

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 spreadsheet is copied into a new job, whenever the spreadsheet is updated and closed, 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. As suggested, here's the root of the question:

How do I automatically, on closing this source workbook, update cell D24 into file C:\MyFiles\Excel\FormerFile.xls Sheet1 cell B27?

Thanks for the help.

Johnny