Auto filling dates on other worksheets with data from a next payme
 

I need to be able to take the data from a Next Payment Date and on that same
line take the information and populate the next date of the payment in excell
on other worksheets and other spreadsheets (that are set up as other months).
How can I take the data that I want from the current date and transfer it to
the next payment date automaticly (ie...I put in the Next Payment Date and it
sends just the name file number and the bal after the last payment to the
current bal section on the specified date in the next payment date section)?