I am trying to create a main document that will read various coloumns from
different sheets in a workbook but put them all in one place.

i.e. In Document A I have - page 1 coloumn A, page 2 Column A, Page 3
coloumn A. I want to see all these coloums in Document 2 coulmn A. I want
the coloumn in Page 2 to pick up lines 1 to 1000 in each of Documents A's
pages, missing out any blanks - if possible.
Thanks