Search across sheets in function

Just when you need to search for a thing across sheets in a workbook.

I am bored, so I am adding articles from my old archive.

=COUNTIF(OFFSET(INDIRECT(ADDRESS(1,1,1,,C$4)),0,0,65536,255),Search_Result!$B5)