In my recent questions I've asked help with creating our company's order
forms. Awesome by the way!

We currently have a macro which adds a fresh new sheet (or order form) to
our workbook.
These order forms have fields to fill out mailing information, but we also
have some fields which allows us to order product names in one field and the
cost will pop up in another.
There are dollar amounts showing up everywhere...

On another sheet I'm able to tally all of these orders and figure out a
bunch of things for the company... But I want more.

I want to have all of this information (on the order forms) to appear on
another sheet and then I will be exporting that sheet and saving it as a
*.csv so that we can upload it to a company site.

I know how i can relate each cell on this new table to an order form's cell,
however I'm not sure how i'm going to add a new row of data for every NEW
sheet that's added to the worksheet...

I hope I've made that clear.

Thank you in advance.

G