how to move a cells value elswhere, depending on combobox linked cell

Hi

Basically I need to populate a range of cells, in a position depending on combobox selection.

the basic principle is as follows.

Cell A1 has value 50
Cell B1 has combobox linked cell, value = 2

I need the value from A1 to appear in C1,but shifted by 2 spaces(as in linked cell). So 50 appears into cell E1


Likewise if combobox had value 5, then 50 would be shown in H1 (which is C1 shifted by 5, as in combobox linked cell)

I have attached an example.


I have brainache! would really appreciate any words of wisdom.