VBA Browse to a folder and merge specific Sheets from Row25

[jskasango]

HELP! need a VBA code to browse to a folder and subfolders and merge all used rows starting from Row 25 in a sheet named "Stocklist" into a new Master workbook and name it Master stocklist. Row1 contains headers and row2 to 24 should be ignored completely. Column A of the destination sheet should contain the path and filename of the source data. Please. Thanks in advance.

 

[jskasango]

Found this code in another members reply.
This is ALMOST what I am looking for, except that all the workbooks of my source the worksheet is named "Stocklist", the data starts at row 25 and should be vertically appended instead of creating a new sheet for every worksheet found in the folder/subfolder. Should skip non excel files.
here is the code I am referring to:-

Sub CopySheets()
    Application.ScreenUpdating = False
    Dim MyFolder As String, MyFile As String, srcWB As Workbook, desWB As Workbook
    Set desWB = ThisWorkbook
    With Application.FileDialog(msoFileDialogFolderPicker)
        .Title = "Please select a folder"
        .Show
        .AllowMultiSelect = False
        If .SelectedItems.Count = 0 Then
            MsgBox "You did not select a folder."
            Exit Sub
        End If
        MyFolder = .SelectedItems(1) & "\"
    End With
    MyFile = Dir(MyFolder)
    Do While MyFile <> ""
        Set srcWB = Workbooks.Open(Filename:=MyFolder & "\" & MyFile)
        With srcWB
            .Sheets(1).Copy desWB.Sheets(desWB.Sheets.Count)
            .Close False
        End With
        MyFile = Dir
    Loop
    Application.ScreenUpdating = True
End Sub