Excel testing and proofing

Hi
The scope of work is to undertake testing and proofing of the four spreadsheets and then make good formulas on each sheet and formulas connecting the spreadsheets.
1 Enrolment
2 Accommodation
3 Cost projections
4 Summary

Some issues but not limited to
1 Enrolments sheet

Summary, Total Required Rooms not added correctly
Total Available Rooms not added correctly
Different not added correctly
2 Accommodation

Constructed additional sq meters are not working and developing errors
Total construction is not working and generating mistakes.