excel text data duplicating
 

I would like someone who has excel experience to answer this question please.
I have a workbook with 6 pages and i am putting words in cells b5 thru b45
and i would like those words to automatically go to a seventh page (a total
sheet) that would list all of the words on one page. so, there would be a
total of 240 words on the total sheet. is there a way to have these words
automatically go to the 7th page as they are entered individually on each
page?

kind regards.