No, I don't think it is macro time

Try this:

In I2 of Setup sheet, enter: =IF(H2='Team Overview (Breakdown)'!$F$3,COUNT($I$1:I1),"")

and copy down to bottom

then in say, G3 of the Team sheet enter: =MAX(Setup!I:I) (you can match font to background colour to hide it)

Then in D5 enter:

=IF(COUNTA($C$5:C5)+1>$G$3,"",INDEX(Setup_Consultants,MATCH(COUNTA($C$5:C5)+1,Setup!$I$2:$I$53,0)))

copy that cell and then paste to each of the other cells in that row to populate.