Hi Tim,

filename, sheetname question is not clear.
by filename do you mean workbook, if so what sheetname and cell
is to be looked at.

If you do not mean filename at all and those are sheetnames
take a look at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

what were you intending on entering
-- a value into cell B2 and have the rest generated
-- or enter a something anywhere in column a and have next ten rows generated.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tim" <tim-martin@echometer wrote in message ...
What I am trying to do is type a .xls file name in a
cell, which automatically lists the next 10 files below
it. Also, automaticlly displaying values of 2 different
cells of each file, next to it.

pt5000

pt5001 34.5467 46.6547
pt5002 3455.56 56.768
pt5003 56.7688 3465.56
etc

.