If I have 2 different tick boxes on for contract and one for quote on one worksheet when they are marked how could I get this to show either quote or contract on another worksheet within the work book.
There are a number of ways. Which one(s) work for you depends on what you're using and
(to some extent) your preference.
If you're using checkboxes from the Forms toolbar, you can assign them a linked cell.
(Right click the checkbox, choose Format control > Control tab > Cell link field.)
Enter any cell you like (out of site if you want.)
(Say the checkbox is on sheet1 & the cell link is A1.)
On sheet2, in whatever cell you choose, enter the formula:
Do the same for the Contract checkbox.
If you're using something different then post back with more details on what you've got
and what you want to do.