Excel VBA - View Hide specific rows depending on value in another row

I've been struggling to try and get anything to work and hoping someone might have an idea.

If C5 has a value I Need Rows 6, 106 and 107 to become visible. I then need it to check if C6 has a value and if so make the next row visible and so on until it reaches row 106.

This will all be run under a Private Sub Worksheet_Change(ByVal Target as Range).

I hope this makes sense any help would be greatly appreciated.

Thanks

Drew