Read a Range Name, Table or Sheet from all Excel files in a Folder using Power Query
If you have a bunch of Excel files that all have the same structure, you can easily pick a table name, sheet name or range name that exists in all of them and read that one item from all workbooks into a single table using Power Query. It's an incredibly useful tool for situations such [...]