Deleting "0" rows

[elad]

Hi.

I have a sheet (travelstat.xls) that gets data from underlaying subsheets (line_1.xls, Line_2.xls....etc.. ). The number of rows in the subsheet will not be constant, so I have made enough rows in the travelsheet to be sure it would not overwrite cells. This gives med many blank rows that I have to delete manualy after the subsheets are linked. Is it possible to have a formula that check for "0" rows and delete them? See attachment for more details.

Thanks for any help

Elad
Norway