In the attached, is data validation in column B which refers to a dynamic named range called
drpdwn2 as the list.
The formula was added to the named ranges while the active cell was in row 3:
Code:
=OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0,,COUNTA(OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0)))
It is dynamic both in width and vertical position.