I want to do something but dont know how.
I have a sheet that have the date for the inventory for the products In and out from the inventory(sheet2)
i want to make another sheet(sheet1) in which i Enter in it the data and it shows the data in the other sheet after i click the enter button
for example i want a sheet that have a cell to write the date and a cell to write the number of the order in or out and a drop down to choose the type of the order if it it in or out also a drop down to choose the customer name and different cells for the quantity of the products then all that should appear in the other sheet ...after i click on the enter button

Any one understood any thing ?

picture for sheet 1:
\1

Sheet 2:
\1