Put the following code behind each worksheet and simply change the text message.

Private Sub Worksheet_Activate()
UserForm1.TextBox1.Text = "This is Sheet number 2!!"
End Sub

When the worksheet is activates the text on your userform will change.