Create Loop and stop when done

I have made a macro that copies and pastes data from table to the next. I have created it to do just the "Burn" part. I was wondering if their was a way to loop it through until all of the Selections of "Burn" are done and continue through each kind of selection (Burn, Equipment, Spec In, etc.) And then clear the validation drop down menus as the macro runs or at the end.

I have figured out how to everything but the loop part. I cant figure it out how to have it stop the loop when there are no more "Burn" validation drop down menus.
And, Im sorry but i dont understand what those program lines are trying to do. Is there anyway to explain them to me?

I have uploaded an updated one. It now has clearing the validation menus after use and continuing to "Equipment" after "Burn"

Its a log book. Every time he does a burn, he writes how long the burn takes. It is guaranteed that he will do multiple burns in one day. So each one will appear multiple times.

Everything is getting pasted to Data sheet.

All I'm trying to do is keep track of how long altogether the burns took, how long repairing equipment took, etc.

For anyone wanting to know how i did it, I posted the new Excel Worksheet. MME.xlsm