Pivot Functionality in Regular Spreadsheet

Hello everyone,

I have tried searching for an answer to this question but I may be wording it incorrectly. Within a pivot table, you can click values which opens a new tab (is there a name for this functionality). What I would like to do is have that same functionality within a regular spreadsheet. For example if I have 3 tabs: Tab A has a bunch of formulas and data, including GetPivotData, so cell A2 may give reference to GetPivotData. Tab B is multiple Pivot Tables which is used to source the data for Tab A. Tab C is raw data that is used to source the pivot tables for Tab 2.

If I have a table in Tab 2, I can click a value on the table to create a new tab which contains the filtered data from that corresponding PivotTable. What I am curious on, if there is anyway that I can click the cell in Tab A that is referencing the GetPivotData to open a new tab with the same data.

Basically I want to omit Pivot Tables from Tab A but, if possible, I would still like to allow end users to click cells to pull the corresponding data for that cell.

Please let me know if that explanation was a little too scatter-brained.

Thank you very much!

Thanks for the reply teylyn! This is what I had assumed but figured I would check in anyways.

In the simplest form, what I would like to do would be to have the data in Tab C, say 4000 rows and 15 columns. Tab B has multiple pivots but in my specific need, the pivot table would basically only have 1 row and then the count. So basically the row is made up of 70 unique values and then the original 4000 rows are all associated with those 70 values.

Tab A would have a formula in say A4 that uses GetPivotData to look for the value in A2 and then return the corresponding count. So A2 has John Smith, A4 looks like "John Smith" in the pivot table and returns the corresponding count, ex: 34. I would then like to click that 34 to open those 34 rows.

I don't mean to just re-iterate what I had already explained but figured I would explain a little further on the off-chance the data extract is small enough that it could be done. Either way, I figured it would have to be done by coding, which wouldn't necessarily be out of the question, I would just need to know how to explain the ask.