Multiple input forms to Master file

Hi Guys,

I'm new to the forums with a work related question. I was asked to find an elegant method to optimize an internal ordering procedure. Basically, there are several departments who all order products at a central warehouse. Most order daily, some more irregular.

The order forms are uniform, but at the moment they are being filled out by hand and have to be manually put back into Excel for registration purposes. Because users have limited access to order systems, locally placed Excel sheets that link to a master file seems the most viable option right now.

What I want is this:
- a user form where users imput their orders (on this part, I'm good to go) that has an input range (let's say: D5:D42)
- a big red button that says "Order Now" (good to go), which takes all the input values and copies them over to a separate workbook (I assume VBA can handle this. I've looked at several threads around the internet (including a few on this forum), but I'm not experienced enought with VBA to actually translate the code to wat I need from it.).
- a master file that receives all the data from several departments, which can be used for montly/quarterly/yearly analysis. (on this part, I'm also good to go).
* this master file needs to be 'invisible' to users, so without actually opening the file when an order is sent.
- an addition that puts a date stamp (preferrably a Now() function to include the time) into the maste file the moment the order is sent.
- the order form to be 'reset' to blank values after it's been submitted.

I hope I've made my problem clear and any imput is very much appreciated.