No worries,
Not like I'm going get any extra junk mail in my hotmail account.

OK,
I've got your workbook, and I've figured out where the code is.
I've resolved the copy issue on ps2, and removed the formula's from the final sheet. My copy is getting some NA errors, but I'm assuming that's because I'm bypass the normal population method to run it. I've also removed some blank events from the job_spec_sheet that were causing the enable macro's message to appear, which eliminates the need to erase the methods programmatically.

NEXT PROBLEM TO RESOLVE

That the last problem is the request to update links. These are appearing because you have checkboxes linked to your other workbooks(In the release.xls workbook) using the linkedcell property for the checkboxes.

Are those links needed? If they are needed, then I will need to do some research to figure out how to copy the checkboxes without the linked cell property, and keep the current state of the checkbox.

Let me know.

Cal