Distribute ranges as per Plan

[ayazgreat]

Hi Kris

I need your help to develop codes which will read ranges (Plan Sheet) data from col a to c and distribute these ranges as per distribution data starting from col e2 (first 3 digits of row first are prefix of range) to onward and copy result to result sheet. I know that somehow it is difficult but you can resolve it.
I am attaching an example sheet.

Thanks in advance