One loan payment ends...another begins!

On the 'Cash Flow' tab, Column G contains loan amounts until completed. Payback period can be adjusted through the 'Data Input' tab. The loan payments in Column G are calculated by a loan calculator found in the Debt P&I tab. When the initial loan is complete in Column G, there is a residual amount owing that must now be financed using a separate loan calculator at tab 'Debt P&I (2). The second loan start line in Column H in the 'Cash Flow' tab, must begin on the line just after loan one is complete in Column G. The loan payment in Column H must run for the specified payback period set by the loan calculator and as input in the 'Data Input' tab. I can attach the entire spreadsheet so that this can be visualized if someone believes that this can be accomplished.