hi Hammer_757
As you probably know this names range will be dynamic and off one column
=OFFSET(Sheet1!$A$1,0,1,COUNTA(Sheet1!$A:$A),1)
Do have list from x's you would need helper columns to seperate the data