Set Up Payment Record Sheet?

I am trying to set up payment record sheet as follows

First Tab: This is the total value of each item, with the payment date in cell C1

Second Tab: Is the payment date of the item

Third Tab: Is the payment due tab

So what I want to do is enter the payment in C1 on the first tab. Then on the second tab I want to enter all the items that want paying on that day, but this will also have previous payment dates shown as a sort of record of what was paid on what day.

On the third tab I want it to show all the payments that correspond to the same date as C1 DATEVALUE

And on the gross tab I want to show all payments to date including the current date.

I have got the payment date to work but I cant get it to show all the previous values.