Relating cells in a row in one sheet to cells in columns on another sheet.

[mbesspiata3]

I have a row of cells that will be entering data in on one sheet (say A1:A12). I have another sheet in the same workbook with the same data but spread across columns c3:n3. I use these two sheets for updating charts. I currently have to enter this same data information on both sheets. I've been trying to find a way to place a reference to the one sheet so I only have to enter the data once and it updates the other sheet. The issue also is that I can't drag my formula across the cells.

Is there any way to make this work?

[xor]

There are more ways to do this. One way is shown in the attached.

[mbesspiata3]

That seems too simple. Thanks so much for your help.
Greatly appreciated.

Mike