This video shows how to use Excel's Power Query to combine data from different Excel worksheets. The video also shows how to bring data in from a pdf into Excel using Power Query as well as how to refresh data that has been added into the data sheets after they are initially created.