Learn how to combine Excel files with different sheet names using Power Query. Save time, reduce errors, and automate your data consolidation ...

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.