Sub sheet_merge()
Dim i As Integer
Dim lRow As Long, lCol As Long, lRow2 As Long
Dim newSh As String
Dim Sh As Worksheet, myFlag As Boolean
Application.ScreenUpdating = False
newSh = "全データ"
myFlag = False
For Each Sh In ThisWorkbook.Worksheets
If Sh.Name = newSh Then
myFlag = True
Worksheets(newSh).Cells.ClearContents
Worksheets(newSh).Move before:=Sheets(1)
Exit For
End If
Next Sh
If myFlag = False Then
ActiveWorkbook.Worksheets.Add(before:=Worksheets(1)).Name = newSh
End If
Worksheets(2).Range("1:1").Copy Worksheets(1).Range("A1")
rast_row2 = Worksheets(1).Cells(100000, 2).End(xlUp).Row + 1
For i = 2 To Worksheets.Count
With Worksheets(i)
rast_row = Worksheets(i).Cells(100000, 2).End(xlUp).Row
Worksheets(i).Activate
Range(Cells(2, 1), Cells(rast_row, 16384)).Copy Worksheets(1).Cells(rast_row2, 1)
rast_row2 = Worksheets(1).Cells(100000, 2).End(xlUp).Row + 1
End With
Next i
Worksheets(1).Activate
Range("A1").Select
Application.ScreenUpdating = True
End Sub