I've got a fairly complicated workbook. The lead worksheet
picks up matching cell info in several other worksheets.
I'd like to have a duplicate of this lead sheet that,
instead of returning the "sum" formula result, would
return a list of which worksheets in the formula have a
value that is not zero.

Basically, I need to know which worksheets are producing
values for each cell. More like a reference page. I could
see that cell D15 in my lead worksheet is picking up non-
zero values in 3 of the other worksheets because the cell
would list either the worksheet names or some other cell
that would identify the worksheets.

Does this make sense? I'm not even sure where to begin.
Lookup or some kind of table? I really have no idea,
though I'm positive there's a way to do this. Thanks.