Returning non blank cells fro multiple worksheets

Hey,

I am looking to write a formula to return non blank cells from multiple worksheets. The slight complication is that I need to return the value that is in the non blank cell, and the value of the cell to the right.

In the attached document, I am looking to return the non blank values from the tables on sheet 1, sheet 2, and sheet 3 into the blue highlighted columns (G,H) on the final tab. As you can see, if the cell is non blank, I need the name and the segment to be returned.

If that is not possible, there is the option of using the table on the final tab which just pulls all of the values from the different worksheets into one table. From there, I still have the same problem of getting rid of the non blank cells from two columns

Cheers,
B