The one workbook will have a price list the other will have all the quote
sheets. At first I had a page with the mark ups and hourly rate in the
first workbook that they were used on another page to mark up the products.
But I realized that this wouldn't work because an changes in the first book
would make those changes to the other work books when they got opened -
creating a huge can of worms so no I need to move the control sheet to the
quote work book. But this will mean changes all the formula a very time
consuming and tedious process. Can I set up the formula in the control
worksheet and have it as a cell reference effect the contents of that cell.
This is one of the formulas that I need to use:

=IF(Questionaire!$F$16=1,I1073,IF(Questionaire!$F$ 16=2,I1073*'Look up
tables'!$D$9,IF(Questionaire!$F$16=3,I1073*'Look up
tables'!$D$10,IF(Questionaire!$F$16=4,I1073*'Look up
tables'!$D$11,IF(Questionaire!$F$16=5,I1073*'Look up
tables'!$D$12,IF(Questionaire!$F$16=6,I1073*'Look up
tables'!$D$13,IF(Questionaire!$F$16=7,I1073*'Look up
tables'!$D$14,IF(Questionaire!$F$16=8,I1073*'Look up tables'!$D$15,""))))))
))

Any suggestions?

Marc