Hi,
This is no task for AutoHotkey, but more a combination of Microsoft Access, Excel and VBA of the two, since the source file has the same name.
We could introduce AHK also, but it would complicate things.
I can help you with this, and it should not take more than a day, using the above mentioned.
I am looking forward to work with you,
Dorian