cant get userform label to display cell value

I have been searching forums and the web for an answer to this with no luck so far. I have an add-in that I would like to add a report popup for. I am using a userform to make this report. I want to use a cell value that changes once daily to populate. When I run the userform, the values do not show up. they just show "lable1".

Private Sub Label8_Click()
               
    Label8.Caption = Worksheets("W G S").Range("K48").Value
    Label9.Caption = Worksheets("W G S").Range("K54").Value
    Label10.Caption = Worksheets("W G S").Range("K56").Value
    Label11.Caption = Worksheets("W G S").Range("K58").Value
    Label12.Caption = Worksheets("W G S").Range("K46").Value
    Label13.Caption = Worksheets("P A R").Range("Q24").Value
    Label14.Caption = Worksheets("P A R").Range("S24").Value
    
End Sub

I don't understand why the values are not showing up. Any help or insight would be greatly appreciated.

Thanks,

Rob