Transferring Data Between Sheets (Excel VBA)

So I'm trying to do a complicated data transfer between one "master" sheet and multiple "sub" sheets. Today is my first day with Excel VBA so I'm pretty lost haha. I decided to start small and transfer data from one cell of one sheet to the other sheet but I keep on getting this error of "Cannot jump to 'Sheets' because it is hidden". Can anyone please lend me a hand? Thanks in advance.

Shi

Sub transfer()
Dim strSourceSheet As String, strDestinationSheet As String, sourceData As String
strSourceSheet = "profile list"
Sheets(strSourceSheet).Activate
sourceData = Sheets(strSourceSheet).Cells(30, 37).Value
strDestinationSheet = "RADIANT OPTO-ELECTRONICS CORP."
Sheets(strDestinationSheet).Activate
Sheets(strDestinationSheet).Cells(C, 11) = sourceData
End Sub

Thanks for the response, did that but the error still pops up ):

"Cannot jump to 'Sheets' because it is hidden"

I assume the Destination Sheet is already visible? Try this

 
Sub transfer()
Dim strSourceSheet As String, strDestinationSheet As String, sourceData As String
strSourceSheet = "profile list"
Sheets(strSourceSheet).Visible = True
sourceData = Sheets(strSourceSheet).Cells(30, 37).Value
strDestinationSheet = "RADIANT OPTO-ELECTRONICS CORP."
Sheets(strDestinationSheet).Cells(C, 11) = sourceData
Sheets(strSourceSheet).Visible = False
End Sub

Apologies for the cross-post!