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.

1.)We create two new sheets a week saving them as the date we open them so starting new everytime.
2.)I dont think that any of them have formulas that need to be written. They type the dollare amt in on the Tab page.

I think I will probably have to change the form on the Tabs page some also to be able to have a cell that has the information for a couple of the ones on the summary page also. If I have something to just get me started in the right direction I think I can just make the changes to make it work.