|Well, without specifics as to sheet names/number and cell references the best I can do is offer some generic code. If the following macro is pasted into the sheet module for all sheets, the specified range will reflect a change to any cell in that range on any sheet.|
I know it is not exactly what you asked for (e.g. 5 out 8 sheets, etc.) but it's the best I can offer without more details.
Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if change was made to specified range
If Target.Cells.Count = 1 Then
If Not Intersect(Target, Range("A2, A3, B1, B2, B3")) Is Nothing Then
Application.EnableEvents = False
'Loop through Sheets setting all cells equal to the changed cell
For sht = 1 To Sheets.Count
Sheets(sht).Range("A2, A3, B1, B2, B3") = Target
Application.EnableEvents = True
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.