Multiple excel files and collating specific cell info

Hi,
I have about 55 excel workbook templates (identical format; different info) from which I need to extract specific cells into a common worksheet to collate all the information. I have seen, in the past, a macro that lists the links to a specific cell in a number of workbooks saved in the same folder, once you have selected the folder where the workbooks are stored; Once the links are displayed you simply change the cell reference and copy/paste in the next column for all the others in same folder and hey presto you have the values for the same cell from all the templates. Has anyone come across this? Or help out in any way? Your help is very much appreciated
Thanks

Hi Steve thanks for the reply and code, but I should have said I am a newbie at this.
I copied the code and then tried changin the file path but am unsure as to what code you speak of when you say:
'DO YOUR CODE HERE
Set rCell = wbCodeBook.Sheets(1).Range("A65536").End(xlUp).Offset(1, 0)

'THIS PUT THE NAME OF THE WORKBOOKS YOU ARE GETTING YOUR DATA FROM INTO A1
rCell.FormulaR1C1 = ActiveWorkbook.Name
Do i have to change the range A65536 to the deired cell or is that a limit of some sort?
For the 2nd portion do I have to enter the active workbook name of all the template files I am extracting data from or the destination workbook (which I am assuming has to be open when the macro is run?

also does this macro only work if all the work books are open i.e. can it not extract the data from each cell from closed workbooks?

Sorry for all the questions your help is much appreciated

Originally Posted by WinteE

Hi,

See the attached file. It will pick up all data in cell B2 of every file in the same workbook as the active workbook is in.

Let me know if you have any questions about this.

Succes,
Erik

Hi Erik
Thanks for your efforts but I cant seem to get it to work? You also say it will pick up cell b2 of every file in the same work book but I need to extract cells from a given same worksheet in multiple workbooks which are all stored in the same folder. I cant seem to view the code for this macro either when I hit alt+f11?
Thanks
Khuram