Merging or Appending Multiple Worksheets to one Worksheet

Hi kopico

Welcome to the Forum!

If I understand your issue, this Code appears to do as you require. You'll need to play with the Formating of the output. I've demonstrated how to do that in the second to last line of the Code

Option Explicit

Sub Merge_Sheets()
    Dim sLR As Long, sLC As Long, tNR As Long, tCol As Long
    Dim sWs As Worksheet, tWs As Worksheet
    Dim sRng As Range
    Dim sCel As Range

    Set tWs = Sheets("Summary")

    For Each sWs In ThisWorkbook.Sheets
        If Not sWs.Name = "Summary" Then
            Application.ScreenUpdating = False
            tNR = tWs.Cells.Find("*", tWs.Cells(Rows.Count, Columns.Count), SearchOrder:=xlByRows, _
                    SearchDirection:=xlPrevious).Row + 1
            With sWs
                sLR = .Cells.Find("*", .Cells(.Rows.Count, .Columns.Count), SearchOrder:=xlByRows, _
                        SearchDirection:=xlPrevious).Row
                sLC = .Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, _
                        SearchDirection:=xlPrevious).Column
                Set sRng = .Range(.Cells(1, 1), .Cells(1, sLC))
                For Each sCel In sRng
                    .Range(.Cells(2, sCel.Column), .Cells(sLR, sCel.Column)).Copy
                    On Error Resume Next
                    tCol = WorksheetFunction.Match(sCel, tWs.Rows("1:1"), 0)
                    tWs.Cells(tNR, tCol).PasteSpecial (xlPasteValues)
                    On Error GoTo 0
                Next sCel
            End With
        End If
        Application.CutCopyMode = False
    Next sWs
    tWs.Columns(1).NumberFormat = "m/d/yyyy"
    Application.ScreenUpdating = True
End Sub

Hi kopico

It'd be much simpler to clear the Summary Sheet and rerun the Code on the updated files...is this acceptable?

Hi kopico

Well, run the Code on

if I have a lot of data in the worksheets how will that affect the worksheets

then you tell me...we won't really know until you try it. You may see a slight degradation of the speed with which the Code completes the task but probably nothing to be disconcerted about.

The proof is in the pudding...try it...let me know.

Hi kopico

I'd suggest it depends on what you wish to do. If you wish to change ANY field then I'd recommend going back to the original concept of rebuilding the file.

If you wish to change specific, limited fields then you need to define what it is you wish to do...Code requires definition else it can't do as you require.

What do you have in mind?