Auto transfer of information from one worksheet to another

[i8ig]

It's probably simple but can someone help me write a formula/macro that takes information entered on one worksheet and transfer it to another in the same workbook by date? Example:
Name Date Rec Date Due
John Doe 7/25/07 8/22/07

I need the same information on an August worksheet in date order as is on the July worksheet.

Any suggestions?