Creating a Point of Sale System in Excel

Hi all.

Is the below possible in exel?

I have an online store.
I use Exel for my accounts and to keep track of orders.
The way i have my Exel set up now is the following:

I have each sale on a row - Starting with the sale date, sent date, customers name etc.

Then i have 3 cells (item 1, Qty, then the price shows automically) Then i have another 3 cells for item 2. and then another3 cells for item 3.

So i have about 6 lots of these 3 cells inline - Then at the end of the row the total cost, how much i sell it for, profit etc.

If the customer only buys 1 item i just fill out the first 3 cells. If they buy 3 items i fill out 3 lots of these 3 cells.

If they buy more than 6 items then i cant really fill it out proberly as i only have 6 lots of these 3 cells.


OK so the question is:
Can i set up a spreadsheet so i enter the date, customers details etc on 1 side.

On the other i enter the product details wheather there is 1 prodoct or 10 - Enter them like as shown.

Then somehow click a button - Have all that info record on another Sheet in a row - So i can check past orders.

And have the variables on the page reset so i can enter another order?

Because there is not a specific amount of items per order, im not sure how to do it?

Thank you =)