You can use copy/paste, you can use formulas such as
=if(isblank(sheet2!a1),"",sheet2!a1) in cell A1 of sheet4 and drag that
formula to adjacent cells.
How much data are you talking about? Is this a one time thing?

"Batmancd" wrote in message
...
I have a workbook with five(5) sheets and I am trying to import data on
sheet
four from sheet 2.