I need a formula to read a cell on several invoices for a customer database.?

Question

there is 150 invoices for each month and the customers name is 58 cells apart in each invoice, the same applies to first name and address and city, I need a formula to add these details to a customer databasae from each invoice.

Answer 1

I made an example spreadsheet to pull out the information. I can not send it to you in yahoo answers because it does not allow attachments. Please send me your email address and I can send you the spreadsheet with the information.