Create an Excel Formula (if its even possible)

I have an excel spreadsheet to record club attendance with multiple sheets, one sheet for each club, on each sheet is a register of names and a UPN for each name and then mark in each column if they attended the club that session or not, each session for that club is in its own column. This is then repeated on the next sheet for each club that exists.

Each person can attend any club, multiple times.

I want to total up how many times the person has attended across all of the clubs, I want it to work going forward as they attend more clubs as well. This can be a process i run to add them, or they add realtme.

I've attached an example spreadsheet so you can see what I mean.

Thank you for reading