How can I make multple worksheet text all show in one box as a tot

[NavyGunner]

I am trying to get a cell on my last work sheet to haev all the text values
from 31 worksheets to show in a single box. IE sheet 1 box 1 says W1R, Sheet
2 box 1 says M1R, Sheet 3 says Y1R, I want Total sheet to say, "W1R, M1R,
Y1R". Is there a way to have that come up like that?

 

[M Kan]

You can use CONCATENATE (cell ref1, cell ref2, ...) to join a bunch of cells
values together.