how do i link cells to tabs and make a certain tal always viewable

Only one worksheet can be active at any given time. So, you can't keep the Front Sheet visible when you go to another worksheet.

If you right-click on the bottom lower left corner (on the navigation arrows) you will get a pop up list of all worksheets in the workbook. From there you can navigate to any sheet easily.

This code uses the worksheet_BeforeRightClick event to navigate to the sheet.
Code goes in the Front Sheet code module. It also uses a Custom Function (below) to test if the worksheet exists.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    Dim strName As String
    Dim lastrow As Long
    
    lastrow = Cells(Rows.Count, "C").End(xlUp).Row
    
    If Target.Cells.Count > 1 Then Exit Sub
    
    If Not Intersect(Target, Range("C11:C" & lastrow)) Is Nothing Then
    
        If Target.Value <> "" Then
            Cancel = True
        
            strName = Target.Value
            
            If wsExists(strName) Then
            
                Application.Goto reference:=Worksheets(strName).Range("A1"), scroll:=True
            Else
                MsgBox ("The sheet named:  " & strName & "  does not exist"), vbExclamation
            End If
        Else
            Exit Sub
        End If
    
    End If
    
End Sub

Place this code into a standard module.

Option Explicit
Function wsExists(wksName As String) As Boolean
    On Error Resume Next
    wsExists = CBool(Len(Worksheets(wksName).Name) > 0)
End Function

Credit for function here by RoyUK - post #3

Another way to create the links is to enter this formula in D1 and copy it to the end of the list. The workbook name is hard coded so you will have to alter that to the real name.

=HYPERLINK("[Grade(1) (1).xls]" & C40 & "!A1",C40)

The only way I know of to keep the front sheet visible:
http://office.microsoft.com/en-us/ex...001217043.aspx

Maybe some VBA expert can come up with code to create the split view with the front page on one side and the desired sheet on the other.

i copied and pasted it but it wouldn't work

Ran perfectly for me when I tested it in your sample workbook.
Did you attempt to alter the code? Did you put it in the correct sheet module? Did you copy and paste the function code to a standard module?