Linking several sheets to one page

[servant117]

I want to take the data from several sheets in a workbook and roll it up into another sheet. I don't need any calculations...just a synopsis of 3-4 sheets into one sheet.

[Palmetto]

Have you tried the Consolidation feature built in to Excel?
It's on the Data Tab of ribbon.

This link may prove to be of help.
http://www.ozgrid.com/forum/showthread.php?t=58025