Okay, a bit less long winded this time. Can anyone provide me with code
for opening up an old workbook, making a copy of a worksheet in that
workbook and saving it within that workbook as "old worksheet"?

That much will get me started.

After that I will work on code for updating formulas in the original
worksheet.

Thank you.