Hyperlinks returns reference isn't valid

Thanks JeteMc

Ill see what I can do with the formula because the work book I attached here just sample, actually workbook is huge with multiple selection ranges across and down.