Link to workbooks

[skoda]

FIRST Regards to the group!

Now question is there a way to do this from below. I have 10 workbooks
named 01.xls - 10.xls. They are identical only numbers and month name are
different. Now I have summary that gets data from them. Summary has
something like this A1 > =[1.xls]Sheet1!A1, B1 > = [2.xls]Sheet1!A1 ...

Now if I want to add 11.xls a need to edit all values in link from 10.xls
to 11.xls. Is there a way to lets do something like this:

A B
0 JAN/06 FEB/06
1 1 2
2 =[A1.xls]Sheet1!A1 =[B1.xls]Sheet1!A1
3 =[A1.xls]Sheet2!A1 =[B1.xls]Sheet2!A1
4 =SUM(A2:A3) =SUM(B2:B3)
..
..
..

Like this I can fill rows when some new xls file appear.

Thanks in advance guys...

 

[Tom Ogilvy]

=Indirect("[" & A$1 & ".xls]Sheet" & row(A1) & "!A1")

Possibly

 

[skoda]

=Indirect("[" & A$1 & ".xls]Sheet" & row(A1) & "!A1")

Possibly

Hmmmm, that could do it. BIG THANKS man!