Excel 2016 consolidating
You can use the Table feature and its associated filters to filter a list so it shows only those items you are interested in seeing and you can create Pivot Tables to look at your data in different ways.You can also consolidate large amounts of data into a summary form which can show you as much or as little of your data as you want to see.When you click Ok, Excel summarizes all the data into your new sheet.; microsoft.support = microsoft.support
Search for excel 2016 consolidating:
You'll see that the worksheets appear in the All References panel in alphabetical order.