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