Thanks Paul!

I have just seen that you can also use the =COUNTA function and
highlight all the worksheets (using Shift) and then click on one of the
column A's to identify the range.