Question from a newbie, sorry if this isn't the right place for it, I am not even sure if this can be done. Here is the situation
I am stuck in.
1. I have monthly filse that I update, and I do it all manually.
2. The problem is there are about 125 files each month that I update, and it takes a long time.
3. My files will be in different directories and each file is only one sheet.
4. I have one directory where all of the files are kept called History, the new files to be added are in a file called New
5. If the file in New is the same filename as one in Histroy, then I copy all the data out of New and add it to the
workbook of the same name in History

Is there a way to set up something to automatically take any workbook in the New folder and if there is a file of the same name in the History folder then copy all the data from the workbook in the New folder and add it to the data that already exists in the workbook in the History folder?

If there is a way to do this it would be great because right now this takes me about 6 to 10 hours to do, and I have to do it twice a month. I was told by a co-worker that a macro is what I need, but I have no idea about any of this stuff. Any assistance any of you can provide me on this would be greatly appreciated.

Thank you in advance for your time and consideration,

Tim Fortune