Change sheet name by linking it with a different cell value

[Bualwafi]

Dears, How can I change the target sheet name in the below formula by linking it with a different cell value, drop-down list, or list box?

[#2]

@Bualwafi 

Please try the INDIRECT() Function!