Button which links the front page to another page depending on a data validation cell valu

Unknown. If you'll post your code or workbook I'll write it up real quick. Best way is to post the workbook, but I understand that sometimes they have data we cannot or do not want to share.