Sub 汇总()
Dim f As String
Dim wb As Workbook
f = Dir(ThisWorkbook.Path & "/*.xls")
Do
If f <> "汇总.xls" Then
Set wb = Workbooks.Open(ThisWorkbook.Path & "/" & f)
wb.Sheets(1).Cells.Find("医疗收入").Resize(18, 6).Copy
ThisWorkbook.Sheets("汇总表").Range("b5").PasteSpecial Operation:=xlAdd
End If
wb.Close False
f = Dir
Loop Until Len(f) = 0
End Sub