I've been searching for a way to do this, and I apologize if a duplicate solved thread is already on here. I have run out of brain cells on search keywords.

I have a 9-worksheet workbook. On a "master" worksheet, column A lists out course names for a curriculum. Column B lists the corresponding week in which that course exists. Each other worksheet provides a week in the curriculum with corresponding courses, times, relevant information, etc.

What I want is for column C to provide a hyperlink to the cell address in the appropriate worksheet, based on the course name in column A.

Example:
A-Name B-Week C-Link
Intro to Engineering 2 "Link to week 2, Intro to Engineering (cell C4)"

Thank you in advance!
Laura