Couple of questions regarding operation of this workbook:

1.) What happens (or should happen) when a job number gets changed on a job sheet?
Asking this with respect to clearing of cells on the job sheet and/or summary sheet, and/or preserving summary of previous job number by adding the new job number to the summary sheet.

2.) Of the cells on the job sheet needing to be written to the summary sheet, which ones contain formulas?
I suspect at least the cells with the dollar amounts would be.