If your question was a bit more specific, someone might be able to assist.
It's unclear to me exactly what you want.

"Chris Wallace" wrote:

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.