Sub TongHop()
Dim fso As Object, FileToOpen As String, Path As String
Dim Darr(), Arr(), i As Integer, j As Integer
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Filename = Array("", "So1", "So2", "So3", "So4", "So5", "So6", "So7", "So8", "So9", "So10", "So11", "So12", "So13", "So14", "So15")
ReDim Arr(1 To UBound(Filename), 1 To 12)
ReDim Arr1(1 To UBound(Filename), 1 To 12)
Set fso = CreateObject("Scripting.FileSystemObject")
Path = ThisWorkbook.Path & "\"
For i = 1 To UBound(Filename)
FileToOpen = Path & Filename(i) & ".xlsx.xlsm"
If fso.FileExists(FileToOpen) Then
Set Wb = Workbooks.Open(FileToOpen, UpdateLinks:=0)
Darr = Wb.Sheets("Sheet1").Range("E9:AB10").Value
Darr1 = Wb.Sheets("Sheet1").Range("C1:AX1").Value
For j = 1 To UBound(Darr, 2)
Arr(i, (j + 1) / 2) = Darr(1, j) - Darr(2, j)
Arr1(i, (j + 1) / 2) = Darr1(1, j) + Darr1(1, (j+1))
Next j
Wb.Close False
End If
Next i
For n= 0 to 20 step 2
Range("I8").Offset(n, 0)Resize(UBound(Filename), 12) = Arr1
Next n
For m= 1 to 21 step 2
Range("I8").Offset(m, 0)Resize(UBound(Filename), 12) = Arr
Next m
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub