I have a one column table in 1 workbook. Every time i enter text such as "ABC", i would that text in that cell to be converted into a hyperlink which is addressed to Sheet "ABC" in another workbook.

e.g.
Wilson, Adam (this will be a hyperlink to tab/sheet "Wilson, Adam" in anotherworkbook)
I was thinking of making each cell a formula such as "if "Wilson, Adam", then...., if "Kite, Alex", then..." but that is too impractical.

Is this possible?