Zend certified PHP/Magento developer

Copying of invoices using vba

I would like to know how I can copy multiple invoice details like, Customer Names, Delivery address from sheet 1 onto a Invoice template. I want to be able to create a new sheet that has all the invoice details on a invoice template. Like A2 to A10 has Customer Name, B2 to B10 has Delivery Address and so on.