I have a spreadsheet that i have created a navigation bar to navigate through the numerous sheets i have, i have the following worksheet change that works but i then want to clear the cells in that row after as i dont want to have the cells with content while not being used. These cells are linking to validation drop downs, which i need one certain drop down to automatically update every time i create a new sheet (of which i am using a macro button to clear certain cells and leave others.

Below is the worksheet change, but i can't work out how to add to this, without getting errors.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("5:5"), Target) Is Nothing Then Exit Sub
Sheets(Target.Value).Activate
End Sub