How do I link data from a cell on one spread sheet to another?

[Richard Deldonna]

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?

 

[starguy]

can you send me sample data like that sheet. then i would return to b
making it what you required.
and please explain your question in that workbook too.
send me at:
(e-mail address removed)

 

[starguy]

can you send me sample data like that sheet. then i would return to b
making it what you required.
and please explain your question in that workbook too.
send me at:
(e-mail address removed)

 

[starguy]

can you send me sample data like that sheet. then i would return to b
making it what you required.
and please explain your question in that workbook too.
send me at:
(e-mail address removed)

 

[Richard Deldonna]

Tanks for replying Starguy, but I found what I was looking for by creating a
new work sheet, and copy the cells I want copied, and pasting special on to
the new blank work sheet.

Thank you for getting back so soon.