Create a summary of different worksheets, leaving out empty cells, starting from row 12

Hi nankw83,

This works like a charm. Thank you very much for your time and effort!
Highly appreciated. :-)

Adding rep and closing my request.