Macro to transfer row of data between sheets based on certain criteria.

Unfortunately I have to go until Monday so I hope this does what you want. Your idea is very doable, however, at the moment I don't have time. I did put this together and I hope it works.

Sub kmc86()

Dim rcell As Range
Dim lr As Long

Sheets("Future Maturities").Activate

lr = Cells(Rows.Count, 1).End(xlUp).Row

For Each rcell In Range("E2:E" & lr)

    If rcell.Value = Date + 60 Then
    
        rcell.EntireRow.Copy Sheets("Current Maturities").Range("A" & Rows.Count).End(3)(2)
        rcell.EntireRow.Delete shift:=xlUp
        
    End If
    
Next rcell
    

Sheets("Data").Activate

lr = Cells(Rows.Count, 1).End(xlUp).Row

For Each rcell In Range("E2:E" & lr)

    If rcell.Value = Date + 365 Then
    
        rcell.EntireRow.Copy Sheets("Future Maturities").Range("A" & Rows.Count).End(3)(2)
        rcell.EntireRow.Delete shift:=xlUp
    End If
    
Next rcell

End Sub