Formula that skips blank rows problem

[omjII]

I am looking for a formula that will look at a column of data(Column A) in Worksheet A, if there is data there, it will put that data in the cell I specify on a different worksheet(Worksheet B) .

This formula is on Worksheet B. I then need the forumula to put the next item of data from Column A onto Worksheet B in the cell directly below it.

The problem is that some of the cells in Column A on Worksheet A are blank. I need the formula on Worksheet B to recognize that there are blank cells, skip those, and use the next item of data.

I have this formula below, but the problem is that it goes row by row, so even if the cell on Worksheet A is blank, when I copy the formula it just goes to the next row. G11, G12, G13, G14 for example.

=IF('OBANs 12, 13, & 19'!G10="","",'OBANs 12, 13, & 19'!G10)

Is there a way to tell the formula to ignore blank cells, go to the next cell with data in Column A on Worksheet A, and put that in the next cell on Worksheet B?

Any help would be appreciated.

Thanks!