Get data from one cell in many files

[SpritHansi]

Hi!
I have one workbook were I have listed info such as name (column B) and address (column C).
In the same folder I have hundreds of workbooks named 101, 102, 103... In theese books, the name is in B3 and adress in B4

Can someone please help me make a autofill-formula I can use in column B and C??

I have tried with this INDIRECT function, but I cant get it working...

Thanks :-)

[FDibbins]

INDIRECT only works on open files. If it is not possible to have all those files open, take a look at the Morefunc add-in

http://www.ashishmathur.com/tag/morefunc/

[SpritHansi]

Aah, thanks :-)