Sub 汇总()
Dim t1 As Workbook
Dim t2 As Workbook
Set t2 = Workbooks("表二.xls")
Set t1 = Workbooks("表一.xls")
For i = 1 To t1.Sheets.Count
t1.Sheets(i).Range("c20").Copy t2.Sheets(1).Range("a" & i + 2)
t1.Sheets(i).Range("c5").Copy t2.Sheets(1).Range("b" & i + 2)
t1.Sheets(i).Range("c6").Copy t2.Sheets(1).Range("c" & i + 2)
t1.Sheets(i).Range("g5").Copy t2.Sheets(1).Range("d" & i + 2)
Next
End Sub
帮你写了前面四格,后面的你自己对照着写吧