Consolidating Excel files

hello,
I've got a project at work and I have to query some information from a number of excel files. They are the exact same format, so I was thinking that rather than querying each of them (via query analyzer), I would like to consolidate them all into one large spreadsheet.
Does anyone know of an easy way to do this?
Thanks for the help!

Hi,

First you try to automate one excel file using vba code. After that, you can process all other files.

CS.