Me again ... while I am here ...

My spread sheet contains a first column with unique values and the remainded
of the colums are referenced in another spreadsheet of data ...

Is there a way to use the text in cells A1 ... A200 as the input parameters
to reference another named workbook of the same name ..

I know I will have to enter the path of these other sheets, but their name
is still the same

MAny thanks again

Alan