Excel find next black cell and delete entire row

Hi, may I ask if anyone know how to find the next blank cell in Excel and delete the entire row that with this blank cell by Excel basic package? 
Also if anyone know how to get cell value from 3 different sheets(in 1 workbook) and set value to another sheet at the same time? 
Thank you!