|re: "then a row should be added to Sheet 1 Row 23"|
I don't know what you mean by "a row should be added to Row 23". You can't add a Row to Row.
Do you mean that you want to add a Row below Row 23?
re: "populates the following info "Pre-Construction Meeting: "
Populates the info where?
Assuming that you mean that you want to add a Row below Row 23 and that you want to populate the new A24 with the info, then try this code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$5" Then
If IsDate(Target) Then
Sheets("Sheet1").Cells(24, 1) = _
"Pre-Construction Meeting: " & Target.Value
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.