Import data from four columns to single column in new sheet

[Guest]

I have Four wookbooks for different customers and each book has a sheet with
key info on spend etc. I want to Extract from each of these sheets key data
and put onto a single sheet. So.. Can i take all the dat from column A of
each sheet and import it to colum A of a single sheet, in a new workbook
keeping it in individual rows?

 

[Ron de Bruin]

Hi Kernow1962

Try this
http://www.rondebruin.nl/copy3.htm

with this example you can select the four workbooks
http://www.rondebruin.nl/copy3.htm#select