Do you want to consolidate data from multiple sheets in Excel in just few clicks? Then you need to watch this video now. In this short video, we teach you how to use Pivot Tables and Pivot Chart Wizard to do this. As you will see at the end of the video, you will be able to create a dynamic report in Excel very quickly.
![](https://i.ytimg.com/vi/p8tZkf1IruM/maxresdefault.jpg)