How to copy last row of data in all worksheets and paste it into one worksheet

[overhead_press]

Currently I have a lot of sheets in my Excel file but I am interested in getting the last row of data in sheets that start with "6" as their names as the other sheets are not relevant. In the sheets that start with 6 are all in the same format but have different number of rows, I am interested in extracting the last row in all those sheets (columns D:J) and placing it into a "master sheet". Since I am quite new to VBA, how would I go about doing that? Thanks in advance!

 

[My Aswer Is This]

So, if we are only going to copy the range D:J
When we put this data in a sheet named "Master"
I assume you want this data copied into the Master sheet stating in column A or is this not the case.
And you said Master sheet. I assume that means the sheet is name "Master"

 

[My Aswer Is This]

If the answers to my previous questions are true, then try this:
Run this script from the sheet named Master

Sub Get_Left_Sheet_Name()
'Modified  2/7/2022  8:53:33 PM  EST
Application.ScreenUpdating = False
Dim i As Long
Dim lastrow As Long
Dim lastrowa As Long

For i = 1 To Sheets.Count

    If Left(Sheets(i).Name, 1) = "6" Then
        lastrowa = Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Row + 1
        lastrow = Sheets(i).Cells(Rows.Count, "D").End(xlUp).Row
        Sheets(i).Cells(lastrow, "D").Resize(, 7).Copy Sheets("Master").Cells(lastrowa, 1)
    End If
Next
Application.ScreenUpdating = True
End Sub