From drop down list selection populate multiple Cells

From the selection from a drop down list(up to 150 selections) I want to populate Multiple cells based off selection, and data Pulled from another sheet.
I have some code already written but is hard coded for only one selection.

see attached sample

From Sheet 'PLC Info' (the Main Sheet). I want to select a Name through a drop down list at Cell C1.

I then want to populate(by the name selected),
Cells C2,C3,C4 and Cells B7:M18 and C32:C35 and B38:M63 and more if necessary,
Depending on amount of data.

Data Taken from Sheet 'HEN5SHFT'(This whole sheet from A1:U501 is named as 'HEN5SHFT')

thanks for the help