Cycle Through Worksheets

I wrote a function that behaves like MATCH(), in that given a reference and lookup range, it will return the entire cell reference, not just the column or just the row.

My function works on the current worksheet, but I can't get it to cycle through all of the worksheets in the book, and return the cell reference with full workbook/worksheet title.

Can anyone show me how to write the loop that would search all of the worksheets? Pretend my function is blackbox, call it cellFinder().

Thanks!

Hey,

is there a way to have a dynamic formula in a cell that makes a for instance the sum of the same Cell (B4) on all tabs?

Cheerios,
Moritz