Macro to create sales report

Hello,

i have a set of invoice] in excel formats in a folder. I need to generate a sales report for this. sales report should contain bill no, date, customer details, customer address, tax amount and bill total amount. in all invoices this comes in same cells. in the report all bill no should come in same row one after another. can any one help me pls
pls suggest me a macro for this in excel