Desktop Tool to find repeated lines in excel documents

Hi, I have 5 Excel files with some repeated data in some lines (column A). I need a desktop tool to go through the files, find the repeated lines (in column A) & erase the line ... but before erasing , needs to get the information from certain columns and put in another file. This is a very bad explanation... but if you feel you can do something of this sort... please quote (anything) and by pm i will give you full details of exactly what i am looking for.... so you can requote after having full details. This should be quite a straigth forward project for somebody who knows what he is doing. If you have read this, please add "456" in your comments. Thanks,