Help with power query to extract and append files from a folder

[Peter083]

Hi, I am new to Power Query and want to do the following:

I have a number of excel workbooks in one folder. Each workbook has exactly the same tabs. The number of workbooks changes depending on what is current. I do this by moving workbooks from one folder to another. In the folder in which I keep the current workbooks I want to extract the "outstanding docs" tab from each workbook and to append the data into one table. In this folder I have a workbook that extracts this data which takes a long time (copy and paste) and as the data in any of the workbooks changes I have to go through another copy and paste which takes forever,

Can someone please help me with code that will automate this task. I am not sure whether a macro or a power query query is the best way to go. Any advice or help will be greatly appreciated.

Thanks

Peter

 

[Matt Allington]

Read my series of blogs

Combine Excel Workbooks with Power Query
Combine CSV Files with Power Query - Excelerator BI
Combine Excel Workbooks with Power Query - Method 2 - Excelerator BI

this should help you understand what can be done, and how.

 

[Peter083]

Thanks Matt, will definitely try this out and let you know.

Best Regards

Peter