Is it possible to subtotal over 100 spreadsheets in a workbook at one

Morning all, I have a workbook with over 100 tabs (all with same heading).

Is there a way to subtotal all tabs at once? I obviously want to perform the same exact subtotal for all but all spreadsheets have different number of lines.

I'm new on here and I've searched for the answer with no success.