mutiple tables in pivot table

[lezawang]

Hi
Does this article makes sense to you? How to Create a Pivot Table Based on Multiple Tables in Excel 2013

The part I am not sure about is this

"5. Click "All" in the PivotTable Fields window to view all of the tables. Excel automatically detects multiple tables, so you won't need to repeat these steps for each additional table"

the author included one table only and yet he is saying that if I click on All then I would see all tables? Any comment please

 

[Anand Sharma]

You can create pivot table based on multiple tables

Press alt + DP it will open a dialog box choose "multiple consolidation range" option

 

[VinodKrishnappa]

With this "Multiple Consolidation Range" option data is consolidating in to one sheet, but order of the data is getting changed. What i mean is similar kind of different files after consolidation columns are getting arranged based on the alphabetical order of the column name.

Can we rearrange this columns as it is in the raw data.