How on Google sheets can I auto sort mutiple Columns on multiple sheets?

So I work in a secondary school, as such we’re trying to make a temporary register that will auto sort. We therefore have a sheet for each year group. So I need multiple sheets to auto sort based on multiple columns, I’ve found information on how to do 1 column on multiple sheets or multiple columns on 1 sheet unfortunately I don’t understand coding well enough to put these things together. I can manage to alter code to make it match what I’m working with but not stick two bits together.
Can anyone help?