Making a data entry form

[chad13]

I want to make a spreadsheet that multiple users can use simultaneously that is made of 2 sheets.

The 1st sheet would be a data entry sheet and look similar to this below and all of these fields would all be in the same row:

Part Number Description Quantity Unit $ Date Validity Lead Time Vendor Cage Code Min Qty ODC Bid #
Once the data is entered, I want a SUBMIT button to put this data in sheet 2 when the button is clicked and the fields would then clear out on sheet 1 which would then be ready for the next entry.

Sheet 2 would just be a sheet containing all data entered in sheet 1.

Hopefully this makes sense.

Thanks,

Chad