Search multiple worksheets for matching cell value and return cell location as a hyperlink

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

Thank you for the reply! It works wonderfully in your example. When I run the code in my workbook, I don't get anything. I suspect it's because I'm terrible at explaining. I don't want to search the Week # in column B. I just want to search the course name in column A, over the full workbook.

In the other worksheets, the course names are not in column A, they are in column C, and their setup is different.
A: other info
B: other info
C: Name of course
D-L: other info


Your assumption is correct, each course name entry is unique and none are repeated.
Ex:
Intro to Engineering
Basic Math
Intro to Statistics
Calculus
Linear Algebra


Sorry about this. I'm a newbie at VB