Dynamic Table with Drop Down List - Only works on one tab.

Hello all!

I have a workbook that has 3 tabs. I would like all 3 tabs to have the identical functionality - where there is a drop down list that creates a dynamic table. The table currently has 1000 rows. I would like to have the option to change the size of the table with the drop down list (the attached file has an example - and it DOES work on 'tab 2') provided on each tab. It is VB code, as seen below:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$3" Then
Range("A1:A1007").EntireRow.Hidden = False
Range("A" & Target.Value + 13 & ":A1008").EntireRow.Hidden = True
End If
End Sub

How can I make this work across all three tabs?

Thank you so much!
-h