Auto generate invoices

[JOJO193]

I have a summary data sheet with numerous data sheets based upon the
information on the summary data sheet. I am trying to auto generate these
data sheets from the summary data sheet.

For example, on the summary data sheets there are columns that are labled
Customer Name, Price per unit, and number of units. I want to generate from
this data summary sheet an invoice after information is typed into the
summary data sheet.

Is this possible and if so, how is it done? Thanks