We have dozens of excel files that we need combined into one. So for example if file #1 has 500 pieces of data and file #2 has 700 then you need to combine them to create 1 file with 1200 pieces of data
You will have to do this for different groups, so for example take 10 excel files and combine them into 1. Then take the next 12 or 13 in a group and combine them into 1 and continue.
Once all of the files have been combined, you must also remove the duplicates if any. (you will give me two final files, one with the duplicates and one with duplicates removed)
This must be accurate and fast we need it done in 1 day