I am wanting to click on an acct name in one worksheet and have the acct
information worksheet pop up.
Example:

Worksheet 1: = ACCOUNTS
A
1 TPA
2 FVA
3 OAKS

If i click on FVA. Then the worksheet named "TPA INFO" will pop up. How can
this be done? Can it all be done in one workbook or does it need to be more?