Dividing data into Quintiles and copy paste into new sheet

Hi Forum,

I am trying to create a macro that can automatically divide each column (from E to P) into quintiles and then copy paste each quintile per name, per fund into sheet2, with the assigned name for each row.

Is that something that can be done?

I appreciate any inputs!