VBA to loop and display data from another excel sheets.

I have a excel sheet to calculate bank interest based on amount of loan and repayment information. Please check the attached file for more details. File description: The file has 4 sheets: Loan VCB, Loan info, Repay info, Interest info. 1. Loan VCB: is overall information of Loan status 2. Loan info: basically get data from Loan VCB sheet 3. Repay info: showing the repayment of Loan 4. Interest info: this file is used for calculating the interest within a period As you can see in this sheet, I had to input Account Number, Repay Date, Repay Amount manually and the data is already there in Loan info and Repay info sheet. I would like vba code to automatically grab the data for me. Here is the logic: Step 1. I would like VBA code to look into Loan info sheet first, then grab the first Account Number, Loan Date, Loan Amount and put into the Interest info sheet. Step 2. Then VBA code will look into the Repay info sheet, looking for all repayment information related to the Account Number in step 1 and display them in the next row. See row 13 to row 16 as an example. If there is no Repayment info associated with the Account Number, then put the repay date as the data from Current Interest Paid on (F2) and Repay Amount = 0 by Default. (check row 54 and 55 for reference) Step 3: VBA code will repeat Step 1, looking for the next Account Number in the Loan Info sheet and so on until it loops all the Account Number in this sheet. Every time I change the F1 or F2 value in Interest info sheet, VBA code will be activate to work from step 1 to step 3 again to update any new repay information