Is this what you mean?

=HYPERLINK("#'SKU Promising IndyUS'!$D"&MATCH(REPT("z",255),$D$2:$D2)+2,"Detail")

copied down