Merge sheets based on keyword in tab

[Mountaineer00]

I have a workbook with about 20 tabs and a third of those tabs have a similar word in tab name, i.e. SALES_Detail. Detail is the same across tabs. Each sheet has identical column headings starting in row 2. What I would like to do is using the Detail in the tab name, merge all sheets into one with the column headings starting in row 2.

I've searched and searched but can't seem to find what I need. Any help would be greatly appreciated.

Thanks!

 

[VoG]

Maybe like this

Sub test()
Dim ws As Worksheet, newworksheet As Worksheet
Set newworksheet = Worksheets.Add
For Each ws In ActiveWorkbook.Worksheets
    With ws
        If .Name Like "*Detail*" Then
            .UsedRange.Offset(1).Copy
            newworksheet.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues
        End If
    End With
Next ws
End Sub

 

[Mountaineer00]

You ROCK! That's exactly what I was looking for. Thank you so much. It is truly appreicated.