Before I go any further I would Like to thank you it is nice when some takes the time and trouble to say that they have the solution and they even say thank you, it is the one thing that tends to tick forum members off...but I think SirJB7 will say some thing about the hero bit
If you click in C15 in your second sheet you will see this in the formula bar..=Estimate!C15
If you select the contents of one to the required cell in your new worksheet and enter the = sign in the cell then switch to your workbook/work sheet with the data in and click on the cell with the data and then press enter that will copy the contents. If you do this in the top most cells of a data set in both sheets you will be able to drag fill handles down.
Oldchippys formula works but you have merged cells if you do not want to have zeros showing in your cells you must unmerge the merged cells.
Merged cells are bad, they screw up your work sheets and formulas.
If you need cells to display things such as titles then :-
Just make sure you have entered the text and selected the correct number of cells and then do the following.
Press Ctrl + 1, in the dialogue box that opens choose “Alignment” tab and in the “Text alignment” section (top left) from the drop down choose “Center across “.