Creating a databse from several Excel files
 

Hi, I have several Excel files which contain data that I am trying to copy
into one spreadsheet. All of the files have the same format, so for example,
I would want to take cell "A:2" from every file and import it into a column
in the main spreadsheet. Is there any easy way to do this? If I have to do
it by hand, it will take forever. Any help would be GREATLY appreciated.

Thanks