insert rows depending on how many are required

hi,

in worksheet1 that could have up to 100 lines depending what the filter that i have produces
in worksheet2 there are headings and footer information
the header information finishes at row 22 therefore i want to insert the required rows in sheet2 to put the filtered data from sheet 1 into.
The footer information is in row 30

thanks
steve