Is there any way to use an IF FUNCTION (or any derivative such as COUNTIF)
with 3D cell (mulitple worksheets) references?

I am trying to retrieve/perform operations on data from mulitple worksheets
within excel. I would like to do this from one page at the end rather than
having to use the IF function on each individual page and then collecting
those results on the last page.

Any help would be much appreciated.