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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]test1[/TD]
[TD]=COUNTIF(Sheet2!A:A,A:A) (the result display would be 2)[/TD]
[/TR]
[TR]
[TD]test2[/TD]
[TD]=COUNTIF(Sheet2!A:A,A:A) (the result display would be 1)[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD]test1[/TD]
[TD]A[/TD]
[TD]1[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]test2[/TD]
[TD]B[/TD]
[TD]2[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]test1[/TD]
[TD]C[/TD]
[TD]3[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]test3[/TD]
[TD]D[/TD]
[TD]4[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="width: 500"]
<tbody>[TR]
[TD]test1[/TD]
[TD]A[/TD]
[TD]1[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]test1[/TD]
[TD]C[/TD]
[TD]3[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]


Is this possible?