Pull information from different files with mult. sheets

Hello everybody,

I am sorry but this one is way over my head so I am asking for help.
I have an x amount of .xls files with the exact same structure. They are all in the same folder but do not have a consistent naming pattern. These are templates containing information. They exist of 13 sheets, individually named. Now I need to create a master list with information from different sheets. These would be something like :
1. Row:Info 1: [file1.xls]sheet1'!$A$5, Info 2: [file1.xls]sheet1!$C$8, Info 3: [file1.xls]sheet2!$E$22, Info 4: [file1.xls]sheet5'!$F$34
2. Row:Info 1: [file2.xls]sheet1'!$A$5, Info 2: [file2.xls]sheet1!$C$8, Info 3: [file2.xls]sheet2!$E$22, Info 4: [file2.xls]sheet5'!$F$34
and so on.
First of all thank you for taking the time to read my post and if you have some spare minutes to help me it would be very vey very much appreciated!!!!
Please let me know if any additional information is needed.

Cheers,

Ace (apperently not in excel )