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!