I am going to try to explain what I need to do. I created a new group of
spread sheets. Each sheet representing a Month, and each month has several
groups, tallied by day. At the end of each month I have created a "Jan Total"
column to talley each group. I then made a sheet to represent each group of
data for all 12 months.
What I want to do is incert the Total of each group for each month in the
corresponding group on the Work Sheet representing all 12 months.

I have tried =January!AG2, =January! to represent the sheet, and AG2 for the
total of that group. It does not work, and I have tried several other
formulas to no avail. Can someone help me?