Dear All,

I have big problem becouse i have one file nemed Base.
I need import some of details from other files (1.xls 2.xls 3.xls etc
etc

each next of field in my sheet should have this same formula but from
next file

for examlpe
=2.xls]Arkusz1'!$E$7
=3.xls]Arkusz1'!$E$7
=4.xls]Arkusz1'!$E$7
=1000.xls]Arkusz1'!$E$7

My question is how to do this by automat if only nale of new file
should by change 1,2,3,4,6,...100,n


Thank you fo your help