Grab only necessary data make new sheet

I have attached an example of what i am trying to accomplish. I have data that i have used formulas to grab. But it is all over the place and some are not even in the right columns etc. Sheet 1 describes how my formulas position the data i get. Sheet 4 is how i want it to look. So i am not sure if i can get a macro that puts all the data on another sheet or what? Any ideas would be great. Also i want it to add some information (see column g on sheet 4)

Oh and only the highlighted data is what i need, i do not need the other stuff. Basically just time periods that have a start date and time and end time.

Thank you in advance.