I am copying data from 3 different columns in 3 different workbooks and
pasting the data into one column in a 4th workbook. The range of data changes
per copied column so I am wondering if it is possible to have a macro that
looks for the first blank space in the 4th workbooks column and pastes from
there down.
e.g.

555 888 111
777 333 1010
999 222 444
1212

The column that I paste to should look like this:

555
777
999
1212
888
333
222
111
1010
444

Any help is always appreciated. Thanks!