Currently I have two sheets in my spreadsheet.

On Sheet 1, I have 3 cells setup for how many tests passed, failed or received an NA (Actually labeling in Sheet 2 is- Pass, Fail and NA). On Sheet 2 (Cells V through AB), it contains PASS, Fail, and NA comments.

Sheet 1 picture:

[![enter image description here](https://i.stack.imgur.com/C2XSA.gif)](https://i.stack.imgur.com/C2XSA.gif)

Sheet 2 Picture:

[![enter image description here](https://i.stack.imgur.com/m8Sxq.gif)](https://i.stack.imgur.com/m8Sxq.gif)

I want to setup what is called I think a hyperlink but it does not function the way I need it too.

What I am trying to do:

For example, when clicking the cell B4 underneath UAT Passed in sheet 1, I want it to navigate to sheet 2 and either highlight or display only the cells that have the word Pass in them (with all the row details as well). I want to apply this to Fail and NA as well.
Along with this, in cells B4 through D4 on Sheet 1, I would want it show to the # of "Pass, Fail and NA" that exists through cells V through AB.

If I am not clear please let me know.

Here is my current setup/formula:

[![enter image description here](https://i.stack.imgur.com/fMvqE.gif)](https://i.stack.imgur.com/fMvqE.gif)