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

This is what I was trying to do at the beginning. Very much looks like it will work for me, although my initial attempts failed. I will certainly give this a try and let you know how it works out. OliverScheurich also offered a formula-based solution below which I'm exploring. Thanks for the Power Query support document as well. Your assistance is greatly appreciated!