Macro - Collect data - Select folder and loop through all xls files

http://www.excelforum.com/showthread.php?t=640124

Bear in mind I am new to VBA!

I have copied the same code that Leigh wrote but it didn't work for me, maybe because my issue is different.

What I am trying to do is collecting data from different excel files with the same format to the master file which has the format as well so I think it should be easy to do it quickly.

The excel file is matrix that people have to fill it in against their names by putting 0,1,2 or 3 in the right cell.

Is there anyone could help me please

Cheers,
Ta