VBA Macro to combine workbooks in a folder into a "Master sheet"

[kyleclark123]

Hi All.

Please can you assist.

I need a VBA Macro to combine workbooks in a folder into a "Master sheet".

1) I have a master workbook named e.g "Coin summary" that consolidates info from various different workbooks (format is exactly the same)
2) The different worksheets ranges (A14:O"Variable") - So will vary on all worksheets but end at "o"
3) Range A1:O13 is standard (header information) and will always remain the same
4) I want however (staff) save the workbooks in a folder names .eg. "ABSA recons",the master sheet should take the data of the various workbooks saved in the folder "ABSA recons" & consolidate into the master workbook
5) Everyday there will be a new folder e.g "10.05.2017" and the files will be carried forward day to day,but the consolidated "master sheet" should just take whatever is on the various sheets

Please can you assist - I can even send an example of format.

kind REGARDS
K

[Bob Phillips]

Power Query has built-in functionality that will do this.

[Zack Barresse]

See http://www.excelguru.ca/blog/2015/02...n-power-query/