I need to create a macro which copies a blank "invoice" to the workbook.
That is pretty simple, however I have a tally sheet adding up costs, taxes,
goods sold, ect.
I need each new sheet to be included on the tally sheet.

I tried to explain this before but now that I've looked over my question I
understand I wasn't very clear.
I would appreciate any assistance given.




I am trying to reproduce our company's product order invoices on the
computer, in Excel. I'm using Office XP on XP Home Ed.

I suppose if this couldn't be done, I could simply create maybe 50
worksheets and include them on the tally sheet. I would need to know two
things for this direction choice however...
How would I record a macro where I would unhide the topmost worksheet on the
unhide list, rather than specifying a sheet's name.
Also, if I go this direction and as we go along using this workbook decide
to change the worksheet names (to names of our clients for example) will i
need to change the reference on the tally worksheet?

Thanks again,

Scott