Adding n rows to a named range

In cell A1 of sheet2, I have a COUNTIF function that is taking data from Sheet1, so the number is constantly changing.

I have a named range on sheet2 called Example from B5:C15.

Is there a way to write a macro that will add rows based on the value in cell A1? For example, if the A1 COUNTIF function returns a value of 5, how can I have excel automatically add 5 rows to the bottom of the range "Example"? Then, if A1 changes, rows are added/subtracted automatically once again?

Thanks in advance for your help!

Have a look at the Calculate Event and the Resize Property of the Range object in VBA help.
These will lead you to the answer.