Mereg workbooks with similar names

[Ads Patz]

Hi All,

I have 2 workbooks with similar names in the same folder location. What i need to do is create a macro that merges the 2 workbooks together into one.

So for example in the file location there will be the following excel files

Adam Jones Dec 17
Adam Jones Dec 2017
Barbara Walter Dec 17
Barbara Walter 2017
Chris Peters Dec 17
Chris Peters Dec 2017

In the Dec 17 version of the excel files there are 2 worksheets
In the Dec 2017 version of the Excel files there is 1 worksheet

So i need the macro to merge the 2 files into one and then save. It doesn't matter if the worksheets are copied from the Dec 2017 to Dec 17 or vice versa. If the macro could also somehow delete the other version of the file that would be fantastic but that can be deleted manually so not worried about that

Any one that can help with this?

Thanks