Reference worksheets in ascending order

[mattjdohm]

Hi

I'm trying to build a summary worksheet that draws various data from other
worksheets with names like "sell 01", "sell 02", and so on. I want to make a
vertical list referencing cell A2 in each worksheet, increasing by one number
for each additional row.

This is easy in the same sheet, i.e., =A1+1 copy->paste. How can I add to a
sheet reference?

 

[John C]

On your summary work sheet, assuming your data starts on row 2, you could use
the following formula:

=INDIRECT("'Sell "&TEXT(ROW()-1,"00")&"'!A2")

the -1 after the row is because you need some method to count which sheet
you are trying to show the value of, if your data on your summary sheet
started on row 7, for example, it would be a -6 instead.

Hope this helps!