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.