How do I get cell info from one sheet combined with other sheets into one new sheet. 10 sheets, each with two main groupes and then further divided into 4 letters?

10 classes
boys and girls
ABCD team

Could you please provide a bit more info on what you problem is?