Awesome!!! I am going to give that a shot and I will let you know how it
works! Thanks so much!
Kendra

"Bernard Liengme" wrote:

Hi Kendra:
You have 12 sheets with data for each month; you want to have some of the
data summarized on another sheet.
Suppose the data you want comes from Z20 on Sheet1, then on the summary
sheet use =Sheet1!Z20 and the cell on the summary sheet will display the
same value as cell Z20 on Sheet1

If you want to sum the Z10 values on Sheet1, Sheet2....all the way to
Sheet12 use =SUM(Sheet1:Sheet12!Z10)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Kendra" wrote in message
...
Actually, treat me like I am 10 and you are trying to explain this to me.
I
am very good at certain functions in excel, so I am not new to it, but
anything with the formulas, I normally only do the SUM of numeric figures,
so
this one is tricky. Sorry to be such a pain! :)
For example - your example of Sheet1!Z20 - what is the Z20 representing?

"Bernard Liengme" wrote:

On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1

Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values

Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kendra" wrote in message
...
I am having a hard time and hope someone can help me!
I have a large spreadsheet that holds data, both numeric and alpha, and
has
12 worksheets within the spreadsheet for each months' data. What I need
to
do
is create another worksheet titled Summary, which would give me a
summary
of
the information I need (not all on each worksheet is pertinant) at the
end
of
each year. It would be easiest if I could create a formula to pull the
information I need and add it to my summary worksheet rather than cut
and
paste each worksheets' information to my summary worksheet.

I hope I explained this correctly.

Thanks everyone!