Hyperlink a 'lookup value' to a specific 'Application Name' on a separate worksheet, within the same workbook

[Justin_M]

Hello, World.

After reviewing similar threads I have found a few that are similar, however not exactly what I am looking for. Up for a challenge? This is Excel, not google sheets.

Overview

1. 6 Worksheets in the workbook
2. Workbook saved as .xlsm with developer options enabled
3. Tabs: 1 Dashboard, 5 Projects (Project 1, Project 2, Project 3....)

Dashboard Tab:

1. The dashboard tab has an 'application name' in column A manually entered by the user
2. On the dashboard tab, column A has the user inputted 'application name'; then there are 5 columns for each Project - e.g. Project 1, Project 2, Project 3....
3. Each of the 5 columns has a value that is imported from each 'project tab', from 'Status' column

Project 1 - 5 Tabs:

1. Column A is the Application Name, user inputted
2. Column B is the Status, drop down box, user inputted

​

Objective: Hyperlink the imported value on the Dashboard tab (for the specific project #/tab, based on the 'Application Name' in column A) to the corresponding 'Project # tab' and 'Application name'.

Issue: The imported value on the dashboard will hyperlink to a specific cell and tab, but not if the value changes.

Hope this is clear? I cannot upload any documents, but am able to explain further if needed.