No. One of the 3 spreadsheets with career titles will be filled in with
various info, depending on the person's specific career and transferred to
the 4th sheet, which is a form.

Susan

"Pete_UK" wrote:

Susan,

you could have 3 hyperlink functions on the main sheet which would take
the user directly to cell D1 on the appropriate sheet if they click
"Soil Scientist" (for example). Is this what you want to do?

Pete