Sub 汇总()
Dim i%, x%
For i = 1 To Sheets.Count
If Sheets(i).Name = "汇总" Then
MsgBox "汇总表已存在"
Sheets("汇总").Move after:=Sheets(Sheets.Count)
For x = 1 To Sheets.Count - 1
Sheets("汇总").Cells(x, 1) = Sheets(x).Cells(6, 3)
Next x
Exit Sub
End If
Next i
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = "汇总"
For x = 1 To Sheets.Count - 1
Sheets("汇总").Cells(x, 1) = Sheets(x).Cells(6, 3)
Next x
End Sub