I need to get data from a total cell in one worksheet into a cell in another
worksheet. Because the source worksheet will have lines added to it, I wanted
to reference the cell by its row and column label (e.g. "Jan Sales"), rather
than by an absolute cell reference. I tried several variations and keep
getting the #REF and #NAME errors.

Does anyone know how to do this?

Thanks.