THANKS FOR THE INFO. What if i only have 20 words on sheet 1 and 10 words on
sheet 2, etc...? How do i get them to automatically recognize the last entry
from sheet 1 so that it will add the words in the next cell where sheet 2
starts. Based on your previous instruction, it sets up the formula for 40
cells before the next page could start to total on the master sheet.

"JLatham" wrote:

On the 7th sheet, in cell A1
='Sheet1'!B5
fill the formula down to A40

On the 7th sheet, in cell B1
='Sheet2'!B5
and again fill the formula down to B40

Repeat in columns C, D, E, and F for the other 4 sheets. Change the sheet
name in the formulas to whatever the real names of those sheets are. The
formulas don't have to start in row 1 on the 7th sheet - but whatever row you
start them in, the formula should be written as shown above and then filled
down for the 40 rows.

"dude" wrote:

i would like to be able to enter text data in cells in column b on 6
different worksheets and then have a seventh worksheet that will display all
of the text data from the six different sheets on it. So, if i list 40 words
in b5 thru b45(one word per cell) on all six sheets, i would like to see all
240 words on the seventh sheet(total "catch all" sheet)

Any help would be greatly appreciatiated.

thanks

dude