I am trying to build an automatic reference to an external workbook.

E.g. using the formula
='http://www.geocities.com/gunther7039/[betonsportslines.xls]Sheet1'!$F$7

returns the value '9'

What I need to do is be able to build the link dynamically and have it
return the proper data.

I want to be able to is separate the link into 3 parts, build it into a cell
and have it return the data

E.g. The below data would be in cells A1:A3 (Because the middle cell, A2,
will change to a different directory)

='http://www.geocities.com/gunther
7039
/[betonsportslines.xls]Sheet1'!$F$7

What I tried to do was concatenate(A1:A3) and return the data through either
a direct or indirect reference, but it just returns a #Value error.

Any help?

Thanks

Ken