COUNTIF across all worksheets of the same workbook

[preythap]

I need to count the frequency/occurance of strings "Manager", "Clerk", "HR" etc. that occur in the exact same column in multiple worksheets of a single workbook.
COUNTIF works ok on a single sheet query but the formula is getting bigger if there are number of worksheets.

Please help me in simplyfing the formula. Also is there anyway to put the formula on the column instead of row wise. I can use a single formula on the column instead on every row in Adminsheet.

To be clear my requirement is to count the occurrence of a search strings listed in Adminsheet column A across all worksheets and display count in Adminsheet column B


Attaching the excel.

Thank you,
Pratap