How do you replicate a formula on a summary sheet in Excel that takes its
data from individual cells in different worksheets? I know how to replicate
formulas when working with one worksheet but not when the formulas reference
multiple worksheets. However, the cell reference is the same on ALL
worksheets and it is the NAME of the worksheet that is different. I do not
know how to replicate to keep the cell reference the same but change the
worksheet name ref in the formula.