I think you need programming to achieve that, VBA may be the common way.

Since I don't know VBA, I will create two ODBC data source for these two Excel files, then use a programming language I'm familiar with (such as Java) to process them, just like normal Database tables, this is far beyond the Excel scope though.