Recreate double clicking in pivot table function in a different sheet?

Question

I'm creating budget reports in Excel and looking to make them a little more user-friendly. Currently, I create a pivot table of the raw data and then use that to fill out a reporting template that summarizes expenses by category. Where users are struggling is being able to see the data that the rolls into each category, as many of them are not familiar with how to use the pivot table in the other sheet. Is there any way I can recreate the function of double clicking a pivot table value (opening all lines captured in the value) on another sheet? I'm thinking this would be some sort of button on the report sheet that would reference the pivot table?

Answer 1

Possible, but convoluted.

Can you link to a workbook with this in it?