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"



thank you for the help~