I have a column on Sheet 1 that has a filter option, when the user updates the filter I need the filter to update on multiple sheets.

The other sheets are fed by the sheet on field input with a simple formula +Sheet1!A4 for example.

I have successfully got the autofilter function working on a single sheet but unable to replicate this on the other sheets.
This is how I have applied the auto filter on sheet 1 on the view code option

Private Sub Worksheet_Change(ByVal Target As Range)

ActiveSheet.autofilter.ApplyFilter

End Sub

I have used the same code on sheet 2 etc. but it doesn't apply is this because the subsequent sheets are not actually changing?