Linking a Cell to Pull Up a Hidden Worksheet on Click

I am creating a macro that will be available from the menu when the user right clicks on a cell in a space we'll call worksheet 1. When they select the macro, a new worksheet (worksheet 2) will populate from a hidden worksheet and name itself after the cell two columns to the right of the selected cell. Worksheet 2 has an area for computations and a value that is ultimately linked back to the original right clicked cell on worksheet 2. When the user clicks worksheet 1, or leaves worksheet 2 in general, I want worksheet 2 to hide until the user left clicks on the original cell in worksheet 1.

That sounds like a lot, but the good news I can handle most of it (I was completely green when I first started coming here, *muscle flex* look at me now). I do not know how to write a macro that will call up the generated worksheet on click for any cell. I am also not sure about what event handler I can use to hide the sheet when it is no longer selected.