how to use macro & page break selection to get to a specific cell

I am trying to use a drop down function on a pivot table page break to take me to a specific row on a different sheet - i have attached a doc that will show what I am trying to do - is there a way to do this
this is my first post so not sure if I'm doing this correctly -