How do i calculate 'TRUE' values across multiple pages of workbook in Excel?

I have devised Audit workbooks with up to 21 pages with Yes/No tick boxes for each question. I have linked each tick box with the Yes/No cell for each question (very time consuming) but I need to now have a final score on the last page to add up all Yes (True) answers so i can then do another formula to calculate the percentage. I have not really got room to add another column on each page as space is limited. I was hoping there is a formula i can use at the end to cover from Page 1 to end? Many thanks in advance

Recent Questions...