Excel 2007 : Dynamically change number of rows based on value in a cell

Not sure I titled this correctly, but here is what I am trying to do:

I have created a generic template to enter test data from up to 100 samples. There are 100 rows (and 11 parameter fields) which represent each sample.

Sheet1 has the information about the samples, including the number to be tested.
Sheet 2 has the formatted table in which to enter the test data.

I would like to be able to have the number of rows in the test table on Sheet 2 dynamically determined, based on the number of samples entered on Sheet 1. For example, lets say a person is only collecting data from 25 samples. I would like for Sheet 2 to only have 25 rows (instead of 100). All rows must maintain their formatting.

What we are doing now is just manually deleting whatever rows are not used, but it would be nice if we could do this "automagically" instead.

Please let me know if this can be done, or if it is just "wishful thinking."

I have searched and searched, but I can't find the solution. My problem may be just knowing how to correctly phrase the question??