Sub mu()
Dim s%, Rng As Range, x
With Sheets("目录")
.Activate
For i = 3 To Sheets.Count
x = Sheets(i).Name
Sheets(1).Hyperlinks.Add Anchor:=Cells(i, 1), Address:="", SubAddress:="'" & x & "'!A1"
.Cells(i, 1) = x
.Cells(i, 2) = Sheets(x).Cells(4, 7)
.Cells(i, 3) = Sheets(x).Cells(4, 9)
.Cells(i, 4) = Sheets(x).Cells(5, 7)
.Cells(i, 5) = Sheets(x).Cells(5, 9)
.Cells(i, 6) = Sheets(x).Cells(4, 3)
.Cells(i, 7) = Sheets(x).Cells(4, 5)
.Cells(i, 8) = Sheets(x).Cells(5, 3)
.Cells(i, 9) = Sheets(x).Cells(5, 5)
.Cells(i, 10) = Sheets(x).Cells(2, 5)
.Cells(i, 11) = Sheets(x).Cells(2, 3)
Next
.Range("b:iv").EntireColumn.ColumnWidth = 14
End With
End Sub