Replace values in worksheet based on cell value

Hello all

Im trying to create a code that replaces a link in my sheet

For example, my sheet contains a links to c:/Team A/2018/Week 1 in Sheet 1

i want to replace Week 1 with Week 2 in Sheet 2

So in an sheet 1 i have Week 1 in cell C4, and week 2 in cell C5

I have tried numerous ways to replace the link but cant seem to do it

How can i use the replace function to search the entire sheet 2 and replace Week 1 with week 2

Any help is always great

Thanks

Dan

thats easier.... thank you