In this tutorial we will show you how to consolidate multiple worksheets into a Pivot table using Excel. If the data is arranged properly, then you can do that. Most of the time when you create a Pivot table in Excel 2013 or Excel 2016, you’ll use a data list, or an Excel table. There might be some different worksheets (or workbooks) that you have in your collection with data arranged differently, but you’ll still want to create a pivot table. If the data is arranged properly, then you can do that. In this tutorial, we will use the consolidating sample file. You can download from here.