Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders/ File Reference for this video: 0266 PQ Combine Files Different Names ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ Tired of Power Query refusing to combine files with different sheet names? Let's face it, we live in the real world where files aren't all consistent. However, that doesn't have to stop us from combining all the files in a folder. In this video, you will discover the methods that let you combine data from any worksheets - no matter what they are called. 00:00 Introduction 00:41 Basic Combine Files 02:10 Different Names 03:16 Combine by Position 04:41 Combine Multiple Sheets 07:23 Wrap Up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel