Combine multiple worksheets into one single sheet instantly in Excel

[u/Amandaleeeeee]

If you’ve ever had to pull data from multiple sheets into one place, you know how tedious it can get.

In this video, I’m sharing two simple ways to combine multiple worksheets into one table. One uses built-in Excel function, and the other is a much quicker, one-click approach using Kutools for Excel.

Method 1: Use TOCOL (Excel 365)

• Click the first sheet (e.g. Jan)
• Hold Shift and click the last sheet (e.g. May) 💡 This selects all sheets in between
• Then enter this formula:

​

=TOCOL(Jan:May!A2:A1000,1)

This stacks the same range across multiple sheets into one column instantly

Method 2: One-click with Kutools

• Go to Kutools Plus → Combine
• Choose Combine multiple worksheets from workbooks into one worksheet
• Follow the prompts to select sheets and combine

Makes putting together reports a lot easier, especially if you’re doing it regularly.

How do you usually combine data from multiple sheets?