Hyperlink to results of a formula in a new sheet

[pochitodiaz]

Hello,

I would really appreciate some help with something I am trying to do or even find out if it is possible, and if so how. I have been looking all over the place but cannot seem to figure it out. I am quite a bit new to using formulas / vba so bare with me. So now to the request

I have 2 sheets, lets call it sheet1 and sheet2, on sheet1 is a "summary table" with a bunch of countif formulas that grab information from the sheet2, I am trying to find a way to make the results from these countif formulas into a hyperlink that would open a new sheet or workbook that cointains the full information used to get the result shown on sheet1. Let me explained a bit further with examples

Sheet1

test1	=COUNTIF(Sheet2!A:A,A:A) (the result display would be 2)
test2	=COUNTIF(Sheet2!A:A,A:A) (the result display would be 1)

<tbody>
</tbody>

Sheet2

test1	A	1	15
test2	B	2	20
test1	C	3	25
test3	D	4	30

<tbody>
</tbody>

Now that the COUNTIF formula gave me the result of 2 I would like that 2 to be a hyperlink that when click would open another workbook or sheet and show the test1 information from sheet2 so it would show as below

test1	A	1	15
test1	C	3	25

<tbody>
</tbody>

Is this possible?