Find percentage IF number present

I have a spreadsheet with 6 sheets. There are 3 sheets that have information regarding the soil, geology and drift deposits of an area. The other 3 sheets relate to these sheets to display the information for each area.

The way that the spreadhseet is set out pretty much explains what i am trying to archive. Basically I want each sheet to say whether or not the rock, soil or drift type is present for each area. And if it is present to calculate the percentage of total area.

I have created a pivot table for each of the info spreadsheets - but need it to look like the "table" sheets, because it needs to be added to a report.

Any questions and i'll try and answer them , but it's quite difficult to explain in words what i am trying to achive. So the best thing is to have a look at the spreadsheet if you think you can help out.

Cheers