Sub test()
Dim s1 As String, s2 As String, s3 As String, s4 As String
Dim wk1 As Workbook, wk2 As Workbook
Dim sht1 As Object, sh2 As Object
Dim num1 As Integer, num2 As Integer
Set wk1 = ThisWorkbook
s1 = Dir("e:\学习\*.xls")
Do While s1 <> ""
Set wk2 = Workbooks.Open("d:\a\" & s1)
For Each sht2 In wk2.Sheets
If Left(sht2.Name, 1) Like "[a-zA-Z]" Then
sht2.Copy After:=wk1.Sheets(wk1.Sheets.Count)
wk1.ActiveSheet.Name = Split(s1, ".")(0) & sht2.Name
End If
Next
wk2.Close False
s1 = Dir
Loop
End Sub