To refer to cell in row 3 column B of a dynamic sheet name in B2, why not? (No helper, ofcourse):
=INDIRECT("'"&$B$2&"'!$B"&ROW(3:3))
To avoid "Zero" from blank cell, try:
Drag down as far as probably need.![]()
=IF(INDIRECT("'"&$B$2&"'!$B"&ROW(3:3))=0,"",INDIRECT("'"&$B$2&"'!$B"&ROW(3:3)))
Bookmarks