Need a formula to identify the next non-empty cell in a column. This
reference woud be used on another worksheet to do lookups against.

Sheet 1 would have a value in cell C5. The next populated cell in
column C on sheet 1 would be C13.
On sheet 2, I'd like to identify that C13 is the starting point and so
on. This would continue for up to 6 sheets, with sheet 3, finding the
next non-empty cell after the one it found in sheet 2 C13, (sheet 3
finding the next non empty cell after C13 that it sound for sheet 2,
lets say C22 from sheet 1 and each subsequent sheet identifying the
next non empty cell in the sequence from sheet 1.

Ideas?

Thanks in advance.

Pierre