This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I tried a technique that put all the Excel workbooks into one folder. Then opened the new workbook. Get data and the various workbooks appeared. I tried to select the workbooks to consolidate into one workbook. After several times I am only able to combine only the first sheet on the various workbooks.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Watch this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.
Hi Randall
I hope these videos could help you
Come back to us if you need more help
Regards
Jeovany
https://www.youtube.com/watch?v=fHFUh6EhBcw&t=135s