Hyperlink click "cell text" to next sheet and auto filter by the "same clicked text" VBA

[determinedtoexceed]

Good evening,

is it possible to have a clicked text hyperlinked to next sheet and auto filter by the same text simultaneously using VBA?

example, "sheet1"click column B4 brings me to "sheet2 C:C C2 auto filter ", then appear "same result as sheet 1 B4"

Sorry, dont know why i cant upload xlsm file anymore on here.

thank you for the help~

 

[determinedtoexceed]

can anyone help please

thank you