You can use actual programming languages to beat up excel: http://www.python-excel.org/ (I'm sure other languages can beat up excel too)

I'm not saying it's a fix for this particular use case, but I couldn't imagine having to manually update a bunch of excel sheets regularly.. talk about a nightmare. ack.