Just a slight change to Bo's formula in B21:

=IFERROR(INDEX(INDIRECT($AG$1),ROWS($1:1))&"","")

then you can copy it down your yellow area.

Hope this helps.

Pete