=INDIRECT("'("&ROW(A1)&")"&"'!B4")

copy down



"Don S" wrote:

I have a workbook with multiple data sheets. Each data sheet has a sum total
in cell B4. I created a summary sheet to pull all the totals into it. I
entered the following linking formula: ='(1)'!$B$4, now I want to drag this
formula down and have it automatically change to the next sheet. For example
='(2)'!$B$4, ='(3)'!$B$4, ='(4)'!$B$4 and so on€¦ Is this possible?