I need a formula to refer to the same cell on multiple sheets to transfer
information to another sheet. The Excel Help directions to me to enter an =
sign and then the name of the function, and then an opening parethesis. Then
for each sheet hold down shift and click on the sheet tab and then the cell.
This is not working. I don't know what the name of the function is.

I have been entering: =('Soil Scientist'!D1,'Engineer'!D1,'Soil
COnservationist'!D1). I've tried adding OR and LOOKUP between the equal sign
and the parenthesis.

These are sheets where people enter their name into cell D1 on one of the 3
sheets, and it transfers it to another sheet, which is a fill-in form.

Susan