Exporting Data and splitting it up!

hi guys,
I have two sheet Program Plan and Staffing Plan-N.
I want to export certain data from Program Plan to the Staffing Plan.
The Range which i want to export is E53:AJ57 (Program Plan sheet) to I5:AN10 in the Staffing Plan Sheet.
But the condition is .
If the cell value in the range is E53:AJ57 is more than 1 then it has to split into 1's so that no cell value in the range I5:AN10 is more than 1.
And the corresponding role in the column E has to be split up to.
The sheet is attached.I have shown in the below cells the expected result.

Thank you guys.

Guys,
I did till this .
I was able to copy from the Program plan sheet to Staffing Plan sheet.
Now I want to convert the data to this format.
can anyone help me on this.
A macro to do the task.
see the attached file for details.