Melissa: A little more information if you please? Can you describe your
workbook?
Perhaps you can use something like this?
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"Melissa H." <Melissa wrote in message
...
I am in need of a way to pull information from multiple worksheets on to a
"summary page" within the same workbook. I am a marketing assistant, and
need a way to condense our order information onto a one page summary.
Please
help, deadline fast approaching!