Examine Multiple Worksheets for Consolidating Information - Moving to the next worksheet once a null value cell is reached

[Lyons900]

I'm trying to figure out a way to search for unique values in a specific column across multiple worksheets. I'm essentially trying to make an auto-generated overview worksheet that looks for the unique values, gathers any required information and generates a table displaying the information. Doing this with a single worksheet is easy enough, but I need a way to tell excel that once you reach a null value on one worksheet, move to the next.

 

[JLGWhiz]

Are you using formu;las or vba/vbs for your current method?

 

[Lyons900]

Are you using formu;las or vba/vbs for your current method?

My preference would be to do this with formulas, if possible.