Use the ampersand '&' to combine text or the Concantenate function.
=+Sheet1!A1&Sheet2!A1&Sheet3!A1&Sheet4!A1&Sheet5!A 1&Sheet6!A1&Sheet7!A1
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Rosie" wrote:

I have a spreadsheet with 7 worksheets. I am trying to include a 8th
worksheet with the text from the first 7 worksheets. They all have the same
layout. Can anyone point me in the right direction?