Excel how to merge files?

[elilab]

I'm trying to merge 115 excel files into 1. Each file has 3 sheets, I want data from 2 of the 3. In both sheets there are 2 columns (one is headers and one is data) and multiple rows. What I want in my 1 file is a big table that says :
File 1 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
File 2 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
File 3 - sheet 1 row1-row2-row3- sheet 2 row1-row2-row3...
etc...

Is there a way to do this quickly, without opening each file by hand?

I saw this add in (http://www.rondebruin.nl/merge.htm) but I can't seem to make it work, it's probably for pc. I don't know how to write code. I have excel 2011 version 14.1.4

Thanks in advance!

 

[Sedulous]

I know how to do this with database software but not with plain vanilla Excel.