Any idea how to carryout an exercise of counting the number of times an entry
appears in multiple sheets' cells A1?

In other words a formula like:
=COUNTIF(Sheet1:Sheet10!A1,"X")

So as to checkout the number of sheets carrying "X" in their respective cell
A1?
--
Best Regards,

Faraz