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?