Start with this and experiment a little
=INDIRECT("["&ROW()&".xls]Sheet1!&A1")

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kicek" wrote in message
ups.com...
Dear All,
I have following problem:

I have one file test.xls and i would like to downloading to this file
some of the date from diferent files

Each next file will have names ( next number ) .xls for example :
1.xls , 2.xls,3.xls etc

How to write a formula if i want to have intest.xls one row with the
same field A1 from each of my numered files



Many thanks
KICQ