How to return counts of text cells across multiple worksheets in same workbook?

I'm working in Excel 365. Windows environment. Working in the Excel app but will be posting to a shared drive for multi-user data entry. 38 worksheets, one for each office.   What I need is to be...