Here's some code to get U started. U will need to adjust your file path to suit. The info will come from the Velocity sheet C1:C17 and be placed in the summary workbook sheet1 "A1" (if the code is placed in sheet code and run from the summary workbook.) If you need to run code from a separate wb then that's different. This will get U started. If this works, it's not that hard to put your file names into an array then loop though the array to get the data from all files placed into your summary wb. U will need to specify where all this data goes in the summary wb. HTH. Dave
Sub test()
Dim FilDir As Object, fso As Object
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Set fso = CreateObject("scripting.filesystemobject")
'***change File path to your file
Set FilDir = fso.GetFile(ThisWorkbook.Path & "\yourfoldername\1056.xlsm")
workbooks.Open filename:=FilDir
'***change range to suit
workbooks(FilDir.Name).Sheets("Velocity").Range("C6:C17").Copy _
    Destination:=ThisWorkbook.Sheets("Sheet1").Range("A1")
Application.CutCopyMode = False
workbooks(FilDir.Name).Close SaveChanges:=False
Set FilDir = Nothing
Set fso = Nothing
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
ps. Welcome to this forum!