Cashflow – VBA – Excel

Hi, I have 4 loans and 4 bank accounts that I want to have an overview by every month and the payments of the loans do not come in at the same date. The Loans have also different amount to be paid and totalt amount of them are different as interest rate and the period.

I want to have a overview of the 4 accounts and see for me which loan I need to pay first and be able to see how to the money will go around.