Help with Macros or formulaes
 

I have a daily input page with group headings. I need these inputs to be move
or copied into another work sheet. But I need all of this to be decided on
what number I put into a set (constant) cell as to decide what column in the
other work sheet it should go to.