Did you mean to say "I have 5 workbooks each with a summary worksheet and I
want to create a new workbook with a summary sheet pulling from the summary
sheets of the 5 workbooks"?

"Pages" are what you print out.


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 10:10:01 -0800, Jennifer
wrote:

I have five workbooks with summary pages using 3-d references. I would like
to creat a worksheet to pull the information from each of the summary pages
into one worksheet.