VBA - adjust Worksheet Change to work across different sheets

[Jasesair]

I have this worksheet change below that works well. I'd like to amend it so it works across worksheets if possible. I'm just not sure how to do this or where to place this in the project(I'm guessing in This Workbook???). I obviously need to add the different worksheet names to each of the ranges so not certain I know how to do that properly either.

Any help would be fantastic - I'm a bit new to VBA.

Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Address = Range("c12:c46").Address Then
Range("$j$2").Value = "Please Select..."

End If

End Sub

 

[Jasesair]

Many thanks Fluff for your support. Really appreciate your time and skills.

 

[Fluff]

Glad to help & thanks for the feedback.