Have you tried Copy / Paste Special and choosing "Values" ?
--
Charles Chickering

"A good example is twice the value of good advice."


"Vince" wrote:

I have been sent approximately 25 different workbooks from my boss who needs
them compiled into one. Whoever designed the layout of the workbook in which
the users supplied their entries used "Drop Downs", that point to "INDIRECT"
and "OFFSET" functions all on one summary sheet. My question is, how can I
take what is on the summary sheet from the 25 different workbooks and compile
into one, without having to open each book, go to each INDIRECT function
which only displays a number, and trace it back to what text data it is
referencing? I will be happy to send a workbook to someone for you to look
at if you think you can help with a solution.

Thank you in advance