Table of Contents from single worksheet

[thedirebear]

I am trying to adapt the table of contents VBA code from the following article:

http://www.mrexcel.com/articles/table-of-contents-macro.php

The original code lists sheet names and page numbers from each sheet. I am working on adapting it to list cells from a column within one sheet and the page number associated with each cell. The relevant work-in-progress code is listed below. Any help would be appreciated.

Sub CreateTableOfContents()
    ' Copyright 2002 MrExcel.com
    ' Determine if there is already a Table of Contents
    ' Assume it is there, and if it is not, it will raise an error
    ' if the Err system variable is > 0, you know the sheet is not there
    Dim WST As Worksheet
    Dim i As Integer
    i = 3
    On Error Resume Next
    Set WST = Worksheets("Table of Contents")
    If Not Err = 0 Then
        ' The Table of contents doesn't exist. Add it
        Set WST = Worksheets.Add(Before:=Worksheets(1))
        WST.Name = "TOC"
    End If
    On Error GoTo 0
    
    ' Set up the table of contents page
    WST.[A2] = "Table of Contents"
    With WST.[A6]
        .CurrentRegion.Clear
        .Value = "Subject"
    End With
    WST.[B6] = "Page(s)"
    WST.Range("A1:B1").ColumnWidth = Array(36, 12)
    TOCRow = 7
    PageCount = 0
    ' Do a print preview on all sheets so Excel calcs page breaks
    ' The user must manually close the PrintPreview window
    Msg = "Excel needs to do a print preview to calculate the number of pages. "
    Msg = Msg & "Please dismiss the print preview by clicking close."
    MsgBox Msg
    ActiveWindow.SelectedSheets.PrintPreview
    ' Loop through each sheet, collecting TOC information
' Loop through each sheet, collecting TOC information
    For i = 3 To 73
        Sheets("Report").Select
' Use any one of the following 3 lines
        'ThisName = ActiveSheet.Name
        ThisName = Cells(i, 3).Value
        'ThisName = ActiveSheet.PageSetup.LeftHeader
        VPages = ActiveSheet.HPageBreaks.Count + 1
        ThisPages = HPages
        ' Enter info about this sheet on TOC
        Sheets("TOC").Select
        Range("A" & TOCRow).Value = ThisName
        Range("B" & TOCRow).Value = PageCount + ThisPages
        TOCRow = TOCRow + 1
    Next i
End Sub