Sub wayy() Dim mcol As Long Dim i As Long Dim arr Columns("B:II").ClearContents Application.ScreenUpdating = False For i = 1 To Sheets.Count - 1 Sheets(i).Select arr = Range("B2:D13").Value With Sheet2 mcol = .[iv3].End(xlToLeft).Column + 1 .Cells(3, mcol).Resize(12, 3) = arr Range(.Cells(2, mcol), .Cells(2, mcol + 2)) = Sheets(i).Name End With Next Sheet2.Select Application.ScreenUpdating = True End Sub