How to create a payment record to be appear upon entering of the loan number

Hello everyone 駱

I need a huge favor. For the past five days, I have been trying to find a solution to an issue I am having.

As shown in the first picture "Shown in the pic as number 1", when I enter a loan number, I need to get the paid record in these columns "shown in the pic as number 2".

The paid details are on another sheet "as DAILY COLLECTIONS".

3rd Raw Highlighted in ?Purple color? shows the dates and vertically shows the paid amounts corresponding to the loan number.

So, the issue I am having is how to get the corresponding details to the "STAT FORM" sheet upon entering the loan number.

I need to get the paid details as to the stat form ?Upon entering loan number?, like a system when you enter loan number and paid details appear as a payment record in STAT Form sheet.

If anyone know a way to make this work. Any formulas or any tricks tips

I?m new to excel and don?t know much about formulas. But i like to learn

I Have attached the sample document

FYI - I?m using office 2019