Dim i, j, k, n As Integer n = 1 For i = 2 To ThisWorkbook.Sheets.Count For j = 1 To ThisWorkbook.Sheets(i).UsedRange.Rows.Count For k = 1 To ThisWorkbook.Sheets(i).UsedRange.Columns.Count ThisWorkbook.Sheets(1).Cells(n, k).Value = ThisWorkbook.Sheets(i).Cells(j, k).Value Next k n = n + 1 Next j Next i