It's kind of possible with some macros.
Please, check the attachment, where I identified the chart and selection to move to another sheet.
In your case, you will need the popup action...
Now,I am really doubting whether I can acheive this or not.
I have not only to capture the field that has been clicked but also the other field values present
in the same row.(like if any field in the table is clicked it should mean that the entire row should be seleceted forcefully).
Coz when I open a sheet then the table present in this new sheet should have values only of that row.
Please let me know if any part of this is not clear.
After you move to the selected sheet, you can use getfieldselection ( FieldName) to get the selection in the field called 'FieldName'.
If you need the values of the expressions, you just need to repeat those expression where you need.
Maybe it would be good for you to lock selection (using actions) after you leave the first sheet, so user selection to open move to the sheet would be preserved.
I'm not sure if this answer your question completely. Maybe if you send some sample application we can give you more details.
Hope this helps for now,