Thanks for all your help.

Those last two formulas did not work. When I cut and pasted it into the cell it returned with the words "Select Earthworks Allowance" and "Select Bridge Length" respectively.

Its looking like with the amount of formulas they are using between the two sheets, it may be easier if they redesigned the workbook so that all the information in held on one datasheet.