I have a data sheet which i want to index pull into another sheet and also concanate or concat 2 or more columns with array formula.

sheet link here

so your issue can be solved as:

=BYROW(DATA!A2:INDEX(DATA!A:A, COUNTA(DATA!A:A)), 
 LAMBDA(a, {a, TEXTJOIN(" ", 1, OFFSET(a,,1,,3)), OFFSET(a,,4,,3), 
 TEXTJOIN(" / ", 1, OFFSET(a,,7,,2)), OFFSET(a,,9,,11)}))