Ok the data is on row 1 of sheet1 but I would like the below formula to
operate from Sheet2 please. What needs to be done please to accomplish this.

=INDEX(1:1,MATCH(TRUE,1:1<"",0))

Thanks in Advance