generate list of data from another data without blank

hi to ALL,
id like to know how to generate worksheet based from another worksheet without blank rows. shall we say in worksheet A,contains data
no. name data1 data2 data3
1 aaa 095 0 099
2. (blank) ---- --- ----
3. fff 0 345 234


how do these data be transferred automatically to another sheet without blank rows. what will appear in the next sheet then would be
no. name data1 data2 data3
1 aaa 095 0 099
2. fff 0 345 234

thanks.
monodon

thank you so much for the link site you gave.it helped me a lot