Merge multiple spreadsheets easily

Do you have experience with Visual Basic for Application (VBA)? The easiest way probably would be write a macro to loop each single file.

Thank you JieJenn - I don't know how to do that, though.
-Joe

Create a workbook and named it Master Table. Press ALT + F11 to open the VBA window, right click ThisWorkbook, Insert, Module, and copy and paste the code.

Move all the files within the same folder. Under View ribbon, click Macro and click LoopFiles and click run. You might need to manually enter the header as I am at work, so I am trying to do as minimum as possible. But I just tested the macro, it loops all the file data into one master worksheet for me. Oh, you also need to change the directory address.

Sub LoopFiles()
    Const strFldrPath As String = "C:\Users\jjenn\Desktop\Loop\"
    
    Dim InputFile As String
    InputFile = Dir(strFldrPath & "*.xls")
    
    Do While InputFile <> vbNullString And InputFile <> "Master Table.xls"
    With Workbooks.Open(strFldrPath & InputFile)
        ActiveSheet.Range("A2:D" & Cells(Rows.Count, 1).End(xlUp).Row).Copy
        Workbooks("Master Table.xls").Activate
        Cells(Cells(Rows.Count, 1).End(xlUp).Row + 1, 1).Select
        ActiveSheet.Paste
        Application.DisplayAlerts = False
        If Workbooks(InputFile).Name <> "Master Table.xls" Then Workbooks(InputFile).Close
        Application.DisplayAlerts = True
    End With
    InputFile = Dir
    Loop
End Sub

Let me know if it works.

Cool. Now I get to brag about during the team meeting today haha...

I guess it worked?