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?