Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
15:33
YouTubeBen Jones Explains
Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
Struggling with inconsistent sheet names when combining Excel workbooks in Power Query? If your queries are hard-coded, the whole process can break. In this advanced tutorial, I’ll show you 5 dynamic methods to reliably pull the right sheet every time — no matter what the sheet is called. What you’ll learn in this video: ️ How to spot ...
231 views5 months ago
Power Query Basics
How to use Microsoft Power Query
16:35
How to use Microsoft Power Query
YouTubeKevin Stratvert
3.2M viewsNov 24, 2020
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Excel Power Query Course: Power Query Tutorial for Beginners
YouTubeSimon Sez IT
985.4K viewsMay 18, 2020
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
28:07
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
YouTubeJosh Aharonoff (Your CFO
266.7K viewsJan 15, 2025
Top videos
Switch Excel Sheets Dynamically with Power Query
1:03
Switch Excel Sheets Dynamically with Power Query
YouTubeData by Jundi
1.2K views9 months ago
Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥
8:05
Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥
YouTubeExcel Off The Grid
18.7K views1 year ago
Power Query - Combine Excel files with different sheet names
1:45
Power Query - Combine Excel files with different sheet names
YouTubeAccess Analytic
36.4K viewsMay 30, 2023
Power Query Advanced Techniques
Power Query Tutorial - Beginner to Advanced [Full Course]
1:54:31
Power Query Tutorial - Beginner to Advanced [Full Course]
YouTubePivotalstats
22.5K views9 months ago
30 Power Query Tricks Most Excel Users Don't Know
58:46
30 Power Query Tricks Most Excel Users Don't Know
YouTubeTrumpExcel
7.7K views2 months ago
Master Power Query in Excel – Complete Tutorial Beginner to Advanced
2:18:45
Master Power Query in Excel – Complete Tutorial Beginner to Advanced
YouTubeEmpowering Finance with
11K views10 months ago

Jump to key moments of Power Query Dynamic Sheet Name

Switch Excel Sheets Dynamically with Power Query
1:03
Switch Excel Sheets Dynamically with Power Query
1.2K views9 months ago
YouTubeData by Jundi
Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥
8:05
Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥
18.7K views1 year ago
YouTubeExcel Off The Grid
Power Query - Combine Excel files with different sheet names
1:45
Power Query - Combine Excel files with different sheet names
36.4K viewsMay 30, 2023
YouTubeAccess Analytic
Power Query - Dynamically transform column names
8:13
Power Query - Dynamically transform column names
4.6K viewsFeb 29, 2024
YouTubeBA Sensei
Power Query: Get data when sheet/Table names change (2 ways) | Excel Off The Grid
8:20
Power Query: Get data when sheet/Table names change (2 ways) | Excel Off The Grid
11K viewsApr 27, 2023
YouTubeExcel Off The Grid
Combine Excel Files Even When Sheet Names Don't Match #excel #powerquery #shorts
2:34
Combine Excel Files Even When Sheet Names Don't Match #excel #powerquery #shorts
1.3K views3 months ago
YouTubeChange tips and tools
Your Power Query Data Source Keeps Breaking — This Named Range Fix Takes 5 Minutes
19:34
Your Power Query Data Source Keeps Breaking — This Named Range Fix Takes 5 Minutes
42 views2 months ago
YouTubeKeith Aul
20:25
Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)
69.6K viewsSep 8, 2022
YouTubeLearn Google Sheets & Excel Spreadsheets
5:55
Dynamic Sheet Switching with Power Query Parameters | Power BI Tutorial
1K viewsOct 22, 2024
YouTubeDriven BI Data
7:10
Create Dynamic File Paths Using Excel Like a Pro!
1.3K viewsMay 12, 2025
YouTubeChethana Pixel
4:27
Dynamically Extract All Excel Table Names In A Workbook With Power Query - Master The Art!
5.1K viewsJan 17, 2024
YouTubeOffice Universe
9:45
Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator)
2.3K views3 months ago
YouTubeBCTI
42:40
Power Query Hacks to Create Dynamic Column Names!
514 viewsDec 31, 2024
YouTubeChange tips and tools
1:55
Want to Combine Excel Files Easily? Watch This Power Query Trick
19.4K views10 months ago
YouTubeTheDataLearner
10:21
Create a Dynamic File Path - Change the Power Query Source Based on a Cell Value
73.6K viewsApr 2, 2022
YouTubeMiss Microsoft
12:29
Combine Data from Multiple Excel Files | Most Dynamic Method (Dynamic Columns & Sheets)
83.1K viewsAug 15, 2023
YouTubeGoodly
12:07
COMBINE EXCEL SHEETS in POWER BI // Customised Transformations // POWER BI / EXCEL / POWER QUERY
1.7K views2 months ago
YouTubeFernan | Power BI
2:23
Merge Columns in Power Query Dynamically Based on Name Patterns
855 views9 months ago
YouTubeOmidBI
31:11
How I Dynamically Transform Double Column Names With Power Query
2.3K viewsJan 6, 2024
YouTubeAlejandra Horvath
8:05
Excel Power Query Parameters: Easily Change Data Source!
7.6K views8 months ago
YouTubeHow to Excel
13:17
Avoid Power Query Failures: The Smart Way to Manage Column Names
16.4K views9 months ago
YouTubeExcel Off The Grid
21:00
Combine Data from Multiple Sheets into a Single Excel File | Most Dynamic Method
36.6K viewsOct 23, 2024
YouTubeGoodly
2:29
Master HIDDEN Dynamic Replacement Technique - Power Query Challenge 56
484 viewsFeb 14, 2025
YouTubeHow to Learn Excel
18:27
Build a Dynamic Excel Budget vs Actual Dashboard with Power Query – Full Tutorial (Free Template)
34.1K viewsApr 23, 2025
YouTubeJosh Aharonoff (Your CFO Guy)
9:24
Dynamic Column Names in Power Query
60.5K viewsDec 9, 2019
YouTubeGoodly
4:38
How to Combine Multiple Tables of Data in Excel Dynamically (Easy Way)
8.1K viewsMay 14, 2025
YouTubeTeachExcel
6:37
Rename Columns Dynamically in Power Query (Column Mapping Trick)
10.8K viewsApr 9, 2025
YouTubeTrumpExcel
8:35
Excel: How to use Power Query to Combine Data from Multiple Excel Files with Different Sheet Names
2.5K viewsJun 9, 2024
YouTubeMike Thomas
6:07
Dynamically Switch Data source (Excel to SQL) with Power Query Parameters | Power BI Tutorials
798 viewsJan 10, 2025
YouTubeDriven BI Data
See more
Static thumbnail place holder