Sorting a list of references that dynamically change

Hello,

I have a worksheet (MMI) of formulas all modifying data from another worksheet (Data). I want to sort the first worksheet (MMI) based on the values and text shown. The hard part is, the data in the second worksheet (Data) is an ODBC and thus gets automatically updated and rows of information are inserted or deleted everytime it updates. The formulas in the first worksheet (MMI) are mostly all index formulas and are dragged down far enough to allow what are currently empty cells to possibly be filled based on the formula.

I've attached an example sheet. I had to delete a lot of data to fit in the requirements of the upload, so a lot of the ship date and line load stuff is missing. Anyway, say I wanted to sort by line load and then by WO#, how would I do that so that when new data comes in, it automatically gets appropriately sorted?