Jump from one sheet to another sheet of same workbook in Analysis for Excel

Hi All,

I have a requirement to jump from one tab to another of same workbook in SAP Analysis for Excel.

Tab1 has a crosstab on one query and Tab2 has a crosstab on another query.Initial layout of both the sheets will have all data,On Tab1 I need to have a GOTO which will go to Tab2 , refresh the data and show only the details of the selected value in Tab1.

I searched for articles on this but couldn't get one. I found one which says that this is not possible.

https://archive.sap.com/discussions/thread/766274

Can someone please provide your thoughts on this?

Thanks.