I used data valadation to create a drop down list. I want the user to select
the name and then the formula would automatically link them to the worksheet
that correspondes to that name. I have tried "if" statements and have not
gotten one to work. Thanks