如果文件太多的话,必须要用宏,看附件,看代码,看GIF
Sub aaa()
Dim f, wb, x
f = Application.GetOpenFilename("EXCEL文件,*.*,", 1, MultiSelect:=True)
For x = 1 To UBound(f)
Set wb = Workbooks.Open(f(x))
Workbooks("test.xls").Sheets(1).Range("a1") = Workbooks("test.xls").Sheets(1).Range("a1").Value + wb.Sheets(1).Range("a1").Value
wb.Close
Next x
End Sub