creating hyperlinks based on the value of 1 cells validation

I am working on a report where i have a list of projects in lets assume Column A. In column B the only values would be either Yes or No.

Based on the values in column B, if "Yes" i want cell B2 with "Yes" hyperlinked, where that hyperlink takes us to tab "project 1" cell A1.

Or the second condition that can work is that if the value in B2 is "Yes" the A2 (Project name) is hyperlinked taking it to tab "project 1 Cell A1?

Can anyone please help. thank you.

example scenario