I'm trying to set up my home based business ans keep track of stock et.

I've set up a workbook with several worksheets.
The first shows all the product purchased, columns for:-
Date:
Invoice #:
Quantity:
Product Descript:
A/Ship (mandatory monthly purchase):
Personal:
Retail:
ReSale:
Promo:
Shipping:
Other:
Cost:

Each of the other sheets id dedicated to one of the catagories, i.e. A/Ship,
Retail, Promo etc.

To save entering each invoice a couple of times, how can I get Excell to
populate the additional sheets when I enter the data in the first?