Sorting Large Data Set with Mixed Data

Does anyone have any good ideas on how to sort mixed data set? I've pulled a 70+ page that I will need to rerun about 60 times over the next few months. I'm hoping I can build a macro or template that will get me to the meat of the data faster.

Cell A2 includes the customer number (6 digits) and A3-A7 includes their last several order numbers (8 digits), A8 includes the next customer number and A9-A20 includes their last several orders... Each customer will have a different number of orders. I'm hoping that I can create a new column that will associate the correct customer number with the correct order number. Then I can apply a number of if statements that will give me the data that should be reviewed by people.

I appreciate any insights! Thank you.