Dynamic Table with Drop Down List

I have a table that has 1000 rows. Most of the time, only 30-50 lines are necessary. I would like to create a table that shrinks and expands, based on a drop down list. So, if the list is comprised of 25, 50, 100, 500, etc., I want that to change the size of the table, so that the table has 25,50,100, 500 rows.

Can this be done?

Thank you so much!
-h

How do I upload a file (I am new to this site, and I just can't seem to find the appropriate icon)?

There you go!

Where do I put the code. I pushed Alt F11, then selected the appropriate sheet, and copied the text into the blank space on the right. Do I do something after that?

Thank you for your patience!
-h

I can get it to work in the example file I attached, but not in the actual workbook I am building. Is there a reason for that? I had to make a change - would that affect it?

I changed it to the following to account where the table is set (see changes in red):

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