Referencing the same cell on different sheets for a summary sheet

[JMillz]

I am trying to create a summary sheet that pulls information from all the work sheets in the work book.

Each sheet is identical from with the exception of the information and the naming convention is (#the the number)
The summary sheet has 5 columns Author (B8), Date Initiated (B17), Responder(B36), Date Responded (D36), Subject (B10).

I have over 100 individual sheets and am using =T('#1'!$B$8) to get the information in cell B8 on the first sheet. How do I pull the formula down so that I don't have to retype the sheet name in to every cell?

 

[Aladin Akyurek]

Thanks so much!! Now I'm curious.... how does "'#"&ROWS($A$2:A2)&" work to change the sheet?? I don't understand the logic.

ROWS(Range) returns the number of rows in the range it is fed with.

ROWS($A$2:A2) ==> 1

Copied down we get with the incrementally growing range spec:

ROWS($A$2:A3) ==> 2

ROWS($A$2:A4) ==> 3, etc.

Glueing to it # with &, the concatenation operator, we get:

#1
#2
#3, etc. as we want.