Populate cells with data from a different file named in another cell

[bikr_mm]

I am not familiar with macros or VBA. I am a basic Excel 2003 user.
I know how to populate a cell with data from another spreadsheet using a hyperlink. However, I want this to be dynamic and automatic. For example, I'm working in spreadsheet one.xls . When entering the name of spreadsheet two.xls in cell A1 I want cells B1 and C2 (or any other cell) to be automatically populated with the specified data from the named file (two.xls). It would be even better if I could leave off the .xls file extension when entering the file name into cell A1. Is there a way to do all of this? Part? None?

Many Thanks!!

[JBeaucaire]

If the files are already open in the background, you can do this with the INDIRECT() function right in the cells B1 and C2.

INDIRECT() doesn't work on closed workbooks. If this is a MUST, then you'll have to install more functionality into your Excel program.

The ADD-IN is called MoreFunc...read all about it here:
http://xcell05.free.fr/morefunc/english/

Download and install it from here:
http://download.cnet.com/Morefunc/30...-10423159.html

Go into TOOLS > ADDINS and activate MoreFunc.

Now you have many, many new functions available to you. Any place you used INDIRECT, now use INDIRECT.EXT instead and it will work on closed workbooks. Only people with the same installed ADD-IN will be able to use your sheet.

[bikr_mm]

I installed more functions and messed with indirect and indirect.exp but don't see how it can help me. I may need to provide greater detail into my query. I have attached a small excel sheet to illustrate what I want to do.

Thank you very much for spending your time on my question!