VBA-code for linking two worksheets together

[All_Might61]

Hello everybody,

I hope you are all doing well and having a nice day so far.
I need to write a short vba code for my boss and I hope, that you can assist me.
There is one sheet called "Evaluation". There is a cell range from B24-B35 with certain actions to reduce costs and their frequency.
The first action type is in B24 defined, the last one in B35.
I have to place a macro button in C24. Should one select the button, he/she should immediately get to the second worksheet "Cost potential",
where the preferred filtre in column B is automatically set on the action type as defined in B24.
Furthermore, I should be able to use the code for every possible action type.
Unfortunately, my vba skills are not the best, so I hope, that you are able to help me guys

I habe sth like this in mind:
IF (B24="action rejected", then go to work sheet "Cost potential" with the filtre "action rejected" in column B and show me all actions with this particular type.

Thanks in advance for all your help!

 

[DrSimon]

The requirement isn't clear. It would make sense to post examples of the Evaluation and Cost potential sheets.