Connect of Workbooks

Dear Guru

I want to make a quotation work sheet.

To keep "Rate"in one workbook, and "Proposal"in one workbook

I want to connect "Rate"and "Proposal "workbook when I want to do the quotation, as all my costs are from "Rate"
after the calculation, I want to "disconnect"the "Rate"workbook while, the calculation will keep in "Proposal".

When I need to redo the "proposal again, I can reconnect them again.

Is that possible?

Best regards
Eric

Eric:
You might just leave them connected but when the proposal is complete, print the proposal to pdf.
Save subsequent pdf proposals with a similar file name, including perhaps a date change or rev. number.

Pete