Thank you Gary

Bob

"Gary''s Student" wrote:

Unusual approach, but:

=Sheet2!C16 & ", " & Sheet3!C16

for two cells, Expand as you need.
--
Gary''s Student - gsnu200909


"BobM" wrote:

I have three worksheets, each with data in a certain cell.
I also have a summary worksheet which displays the contents of the other
three sheets.
What I wish to do is to gather a numerical value from each of the three
worksheets and display in a cell on the totals worksheet as:- value1, value2,
value3
i.e. one can see the three numerical values side by side on the summary
worksheet
Bob