Hey everyone,

I have two folders: 2015 and 2016

In each folder there are 40 files, one file for each customer.

Is there a way I could employ a macro to select the matching files and append them? For example, open "Aveeno 2015" and append it to the "Aveeno 2016" file, open the "Loreal 2015" and append it to "Loreal 2016", etc.?