My organisation runs events that people attend on a voluntary basis. I currently keep a workbook with a sheet for each event where I record their name, age and gender. I then use formula to tally up how many males and females in certain age ranges have attended each event.

At the end of the year, I have to submit a return to my organisation's governing body, telling them the totals for age range and gender across all the events (so it's that bottom table but for all of the events, not just this one). The number of events per year is not fixed, so I could have any number of worksheets, but typically not more than 20-30.

How can I create a separate worksheet with a copy of the bottom statistics table that shows the data for all of the services? I've been wracking my brains but I can't figure it out... I know I could just do it manually but I figure there must be a way!