Sub °´Å¥54_Click()
P = ThisWorkbook.Path & "\Êý¾Ý\"
F = Dir(P & "*.*")
Set d = CreateObject("scripting.dictionary")
ReDim brr(1 To 10000, 1 To 12)
Application.ScreenUpdating = False
Do While F <> ""
Set wb = GetObject(P & F)
For Each sh In wb.Sheets
arr = sh.UsedRange
For i = 5 To UBound(arr)
If Not d.Exists(arr(i, 1)) Then
m = m + 1: d(arr(i, 1)) = m
For j = 1 To 12
brr(m, j) = arr(i, j)
Next
Else: j = 0
For j = 2 To 12
brr(d(arr(i, 1)), j) = brr(d(arr(i, 1)), j) + arr(i, j)
Next
End If
Next
Next
Workbooks(F).Close False
F = Dir
Loop
Range("a5").Resize(m - 1, 12) = brr
Application.ScreenUpdating = True
End Sub