Consolidated List from a range with blank spaces

I have a data matrix that helps me sort out information that is output by my company's reporting program. It details each worker's hours and whether they were on break or working and for how long. There are circumstances under which gaps may occur and that is what I'm trying to capture. In the example you will see that my matrix contains a great deal of spaces. What I'm trying to achieve is a summary of this matrix data that consolidates all of the information, often only 4 or 5 cells of data from 2000+ rows, onto a separate page. Please bear in mind that I know nothing of VBA or any other programming language outside of Excel's built in capabilities.



Example Data.xlsx