按妳的原代碼,修改如下
Sub 批量輸入()
Dim z As Integer
z = Worksheets.Count
For i = 1 To z - 1
sheets(i).cell(1, 1).value = Worksheets(z).cell(i + 1, 2).value
Next
End Sub