I work for a small company. We use XP and Excel 2003. They manually create
each of their invoices using Excel. I have been asked to automate creating an
invoice by replicating rows 1-26 (of course appropriate for each company) and
each sequential row, one row at a time, to separate worksheets. I am new to
Excel Macros and would like to try to invoke a Sub routine that will
accomplish the task below.

During the month, a 'master' worksheet of each order for each client is
maintained. At billing time, a separate 'invoice' is manually created from
each 'order'such that the manual process for creating the invoice is as
follows:

1. copy our logo onto the top left of the worksheet (it takes up space from
A1:C9).
2. A10:A13 is our company info (this data remains constant)
3. A15 is a constant "Submitted Date:"
4. B15 is the date the invoice was created
5. A16 is a contant "Invoice NO:"
6. B16 is a value that varies with each invoice
7. A19:A22 is client address info
8. A26:J26 are constant values for column headers
9. Subsequent rows contain order data under each column header

Each invoice has only 1 row of data from the "master" worksheet. Each
sequential row from the 'master' is copied to separate worksheet along with
the info from steps 1-9 as described above.

On row 27, I 27 is the Sum of F27:H27

On Row 28, in bolded font, highlighted in yellow, and currency format is the
following:
F28 is the Sum of F27,
G28 is the Sum of G27,
H28 is the Sum of H27,
I28 is the Sum of I27

Each sequential worksheet has its own name, which is usually a number, the
first 4 digits are fixed and the remaining digits are a unique value from
column D.

Any help is greatly appreciated!
--
Thank you so much for your help!