Custom lists from different sheets

[Guest]

Hi to all,
I want to create a custom list from linked data from other sheets.
Lets say we create the list on 'sheet10' and the values will be taken from:
'Sheet1!A1' , 'Sheet2!A1' , 'Sheet3!A1' ect....and i want the list to continue till 'Sheet9!A1'. I tried to drag the first three link cells (on sheet10),in order to create the list but the next cells didnt jump to: 'Sheet4!A1',Sheet5!A1'....

Does somebody knows the answer....
Thanks in advance

 

[Andy B]

Hi

One way is to link your formula to the row number, and use this to increment
your sheet numbers. Try
=INDIRECT("Sheet"&ROW()&"!A1")
when you fill this down, the ref will increment with the row number.

--
Andy.

Hi to all,
I want to create a custom list from linked data from other sheets.
Lets say we create the list on 'sheet10' and the values will be taken from:
'Sheet1!A1' , 'Sheet2!A1' , 'Sheet3!A1' ect....and i want the list to

continue till 'Sheet9!A1'. I tried to drag the first three link cells (on
sheet10),in order to create the list but the next cells didnt jump to:
'Sheet4!A1',Sheet5!A1'....

 

[Guest]

Thanks a lot for the answer but still no luck with it.
When i fill the formula down it still filled as same as the upper cell.
no luck.....
can you send me a XLS file for example to: (e-mail address removed)
thanks a lot...