|You seem to be asking 2 different things:|
How can I give a tab in Excel a running total.
This sounds (to me) like you want to SUM all of the individual COUNTA's to get a total.
How can I get the total from each sheet to appear in one tab
This sounds (to me) like you want to see each individual total on one sheet.
In any case, to SUM the totals:
To see each total, it's just: