For some reason I can’t add comments to my old post, that’s why this new post.
A few months back I create a small new Add-in named RDBMerge to merge data from
all workbooks in a folder. I update the add-in last week.
1) You can filter the file names with wildcards
2) You can filter the worksheet names with wildcards
In the next version I will add a option to copy the data next to each other and maybe a autofilter option
to filter the records you want in each workbook.
Do you have other suggestions ?
On my site you also find VBA code examples to do the same and more.
Ron de Bruin