Pageantry Scoring System Development

I need a Google Sheets competition scoring system for a pageantry event. The system should include:

- 4 separate judge's sheets
- Master sheet that aggregates scores
- Categories for both compulsory and optional sections

Compulsory sections: Formal, Fun Fashion, Theme Wear, Interview, Portfolio
Optional sections: Talent, Community Work, Headshots

Overall winners determined by compulsory sections only.

Ideal Skills & Experience:
- Proficiency in Google Sheets
- Ability to develop interlinked google sheets
- Experience with creating scoring systems
- Attention to detail and accuracy