Click on 1 cell to goto another worksheet

Hi All,

Apologies if this has already been done but I cannot find it.

I am trying to click one 1 cell, which will automatically use a lookup of the cell values and find the correct sheet to go to.
All of this using VBA.

I have attached an example

Thanks