Hi,
I assume that your tabs are named "North", "South" etc and the result you
want to pull out is in cell C6 so enter

=North!C6+South!C6+Mid!C6

change range or sheet name to fit your needs

"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