Uploaded October 2023 | Updated September 2026, 2 weeks ago

---

This is an update to a previous video (youtu.be/WV-hobu7Osw) after a few great suggestions from:
@Dan_De_Man and @baskis69


How to consolidate multiple Excel files when the sheet names are different.

Power Query From Folder is very powerful and even more flexible with these 2 techniques.

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
wyn.bio.link