Power query: Compiling workbooks,many sheets in a single sheet.Assembling all workbooks in 1 sheet.
Channel: DSmart Exceller
Date: 2019-07-15

The best way to use PQ, if you have many workbooks and inside many workbooks there are many different sheets, How to have an analysis or apple to apple comparison report in a single sheet. Mostly for Total Facilities management comparison with a perfect report.