VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

Hello,

I have a sheet named "SE List $1b+". The first column in this sheet has client names. I want it when I click on the client it brings to another sheet which has client contact information. Instead of hyper linking manally to the reference, which would take forever because there are over 600 clients, I want the user to click on the client and bring that second sheet filtered, which is called "SE $1B+ accounts with employee" which matches up the client name. Can anybody post code so I can achieve this? Appreciate it!

Here I uploaded a dummy document. On sheet 1, lets say I click on ICBC, I want it too go to sheet 2 and filter out company name with only ICBC contact information. Hopefully somebody can post any code. Thanks!

WOW!! This worked thank you!! What if I want to filter out two different sheets, I have another sheet with more client information that might not be on the first sheet. What extra code do I add for another sheet to be filtered out when I click on the client on the first sheet? Thanks alot!!