Do you mean something like this:

=TRIM(North!A1 &" "& South!A1 &" "& Mid!A1)

?

If you have numbers that you want to add together then you can do
this:

=North!A1 + South!A1 + Mid!A1

Put the formula in A1 on the Results sheet and copy to other cells as
appropriate.

Hope this helps.

Pete

On Jul 29, 12:28*pm, Jimmpy wrote:
I have four pages in an excel workbook and want to link North, South, Mid to
Results, I have entered = into cell C6 in Results but I can only link one
worksheet and I need all three, please help