Find information from every sheet in workbook

Hi,

I have a sheet with attendance recorded, with an individual sheet per pupil. I would like to create a page at the front that summaried this, e.g. took a child's name from each worksheet, their class name and their attedance. Is this possible? I have attached an example of what the indivdual attendance sheet would look like.

I don't know how many sheets there will be or what they will be called yet so need a way to pick it up from them all if that makes sense.

Thank you both, I need it to work on 365 as lots of staff will be accessing it so I don't think I can use VBA in the traditional sense.

I've attached a summary where it would create a list of pupils from each sheet and then bring in their information

Actually maybe I could do this on the desktop version. This is really helpful, thank you. The only other thing I need is to be able to summarise attendance from this week - can you think of how I could look up this week on the year calendar at the bottom of each sheet?

Seems we crossed posts, I think I can use the desktop version which is useful I think.