I have two spread sheets. One called "Lot" the other called "Invoice"

Lot contains all of the billing information for each location.

Store, City, State, Invoice Number, Billing Amount, Sales Tax, Total

I need to compile this data onto the "Invoice" spreadsheet, and print
individual invoices for each store. I figure I will use Vlookup for
everything but the store number, and possibly have a macro input the
store numbers.

Is there a way that I can record a macro to copy the store number
(starting in A7) to the invoice spreadsheet, and have it print....then
copy the data in A8, print...copy A9, print so on and so on, until
there is no more data in A.

Any help you can provide would be great.

Thanks!