Timestamp on worksheet change

[Sportman1975]

Hi guys,

I have to following problem:
in a workbook with many sheets I have to update several worksheets (Store A,B,C,D,E,F,G,H, etc). But I would like to have a overview sheet (Info) where all worksheets are named with a time stamp when the sheet was updated

Overview sheet is called Info
Field A2:A50 contain the different stores

Store Timestamp
A xxxx
B yyyy
C zzzz
D
E
.
.
.

So what I basically need is a macro which update field B2 in Info-sheet when the specific store is updated.
The current code I have to add in every worksheet but that is probably not the right way. PLease help is required....

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
With Sheets("Info")
.Range("c2").Value = Environ("username")
.Range("b2").Value = Now
End With
End Sub​

 

[Yongle]

This thread is duplicated and has already been replied to https://www.mrexcel.com/forum/excel-questions/1078414-timestamp-worksheet-change.html