OK, folks - I can't figure this one out.

I have a worksheet column with a unique number on it that also appears once in a large PDF. I want my users to click on a separate cell in the same row with display text so that it is directed to the PDF, searches the file, and displays the PDF page where that string is located.

So, for example, I have column F8-F200 with a unique number. A user clicks on A8 (which displays the words, "Click for corresponding PDF page"), and the macro searches the PDF for the string in F8, and displays the page where it is found.
Thanks for any help.
Remain awesome.