Cut, Paste, and Transpose data from one worksheet to a second worksheet

I am very new to macros so any help is greatly appreciated.

Sheet 1: "Client Info"
Cells with required data: D7:D31, D34:D39

Sheet 2: "Tracking"
Cells were data needs to go on new sheet: A2:AK2, and then subsequent rows if any data is in previous row.


The idea is, someone would fill out the "Client Info" worksheet, run the Macro, and the data would then be transferred to the "Tracking" worksheet to the next row.

As I stated before, any help is greatly appreciated.
Thanks!

Possibly...

Sub Test()
    Dim lRow As Long

    With Worksheets("Tracking")
        lRow = .Cells(Rows.Count, 1).End(xlUp).Row + 1
        .Cells(lRow, 1).Resize(, 25) = Application.Transpose(Worksheets("Client Info").Range("D7:D31"))
        .Cells(lRow, 26).Resize(, 6) = Application.Transpose(Worksheets("Client Info").Range("D34:D39"))
    End With
End Sub