Auto populate the amount of trailers used

Hello Everyone,

I spend hours creating a plan that should only take seconds; please help. There are 3 sheets ("d load plan", "t load plan", and "n load plan") of information that I input and the results come out on the "equipment summary" sheet. I input the volume located in "G2" on the "d load plan" sheet and "H2" on the "t load plan" and "n load plan" sheets. I got a formula to work on the "d load plan" sheet that pulls information from "sheet1" and automatically adds equipment type. How can I get it to work for the "t load plan" sheet and get it to input the remaining equipment type from "sheet1". Then get it to work for the "n load plan" sheet and get it to pull from whats left over in "sheet1". There are a couple of conditions; the equipment type from "sheet1" will keep getting added until the "excess capacity volume" column is a positive value and the red () disappears around the number in those columns. Also, you will know when you have added too many trailer because cells in "excess capacity load %" column will turn into a red 100%. Usually I would manually enter the equipment type from the list in order until the conditions were met. The "t load plan", and "n load plan" sheet do not have any formulas related to "sheet1". The Any help would be greatly appreciated. I thank you in advance.