Click cell, VBA takes me to source data (Reverse Index)

Greetings all.

I have a column filled with "Index" formulas that use two pieces of criteria to retrieve the proper answer. That's fine and it works.

What I'd like is to click on any one of those index formulas and have excel take the cursor to that source data worksheet (in the same workbook) and put the cursor on the intersection of the particular rows and columns of that table. Essentially, a drill-down, or a 'reverse-index'.

The first piece of data is in a fixed cell, it's a part number. (the part number will change depending on things outside the scope of this question)
The second piece of data is a corresponding column of text denoting a week number.

Attached is a sample spreadsheet.
- Sheetname WORKBENCH contains index formula column "D" that I want to click on.
- Sheetname CONFIDENCE is where the source data is. This is where i want to the cursor to go.

I have some VBA experience, but I can't figure this one out and have searched quite a bit but I can't find a solution.

I am looking for any solution. If a hyperlink formula can work, then great!

Thank you for your attention!

Select a cell in Column D of the "Workbench" sheet and the code will activate to take you to the correct cell in the other sheet.

Please Login or Register  to view this content.

The code that activates the above code is in the worksheet module.

Please Login or Register  to view this content.

Check out the attached.

Oh yes, I see that now,
Try this instead.

Please Login or Register  to view this content.