Can I transfer text in one spreadsheet to another? Users choose one of three
worksheets to fill out and then the info should transfer to a form on another
sheet within the same workbook.

The formula ='Soil Conservationist'!D1, put within the form, worked to
transfer the info when I only had 1 worksheet for info, but I added the other
2 and it doesn't work. I need to be able to tell it to pull the info from
whichever of the 3 worksheets has been filled out. The names of the 3
worksheets are Soil Conservationist, Engineer, and Soil Scientist. One of
the cells I'm working on within them is cell D1, which is where they would
enter their name.

Susan