Select Also search within formulas this will turn all the formulas inside your sheet into text strings. In other words Id like to have the ability to say make a new sheet I make a copy of a blank template in the workbook and the summary sheet would automatically update all formulas to include the cells from the new sheet. This happens because the formula is relative and when I copy and paste it the references will automatically adjust.
Select the cell with the formula and hover the mouse cursor over a small square at the lower right-hand corner of the cell which is called the Fill handle.
In other words Id like to have the ability to say make a new sheet I make a copy of a blank template in the workbook and the summary sheet would automatically update all formulas to include the cells from the new sheet. As you do this the cursor will change to a thick black cross. You can click in the formula bar and edit the formula manually to change aspects of the charted series. If you dont want the formulas hidden when the sheet is protected in the future right-click the cells and click Format Cells.