programatically retrieve selected rows from excel workbook
 

hello
I am very new to excel programming and looking for
a solution. my excel file has many number of sheets with different names,
each for one of the counties in the state. I need to retrieve a set of rows
from all those different sheets and correspondigly store them in a new excel
sheet with the county name being its sheet name.

Is there a way this can be done with a sub routine or a procedure which when
run on my Excel workbook, produces set of different excel sheets with the
rows I need pulled out from each sheet and store them in a new excel file.

thanks for any help
talktobatchu