It looks like you might be able to use microsoft query to do what you want. Here is a page talking about it (
link ).
If it's not sensitive, what type of main file are you making. If it didn't have to be in excel, you would have all sorts of options - like putting the data in a MySQL table and using any number of languages to right a page that uses that data. Just some thoughts. Hope the link helps, and I'll still keep an eye out for you.