Need Excel VBA codes to Automate Inventory

[xpizzy]

I have an excel workbook and I would like to automate it to make my team mates in other office locations to use excel to update stock reports.

I have 6 sheets in the workbook named:
Process: Sheet where automation takes place
Database: Contains all the stock list
Stock Update: Contains the balances and needs to be updated +- based on input from the Stock movement sheets
Stock Movement (Receipt): A listing of entries from the input boxes on the process sheet
Stock Movement (Issues)
Stock Movement(Transfer)

I have the first sheet on the work book like this:

Excel 2010 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​	M​	N​	O​	P​	Q​
1​	Welcome to Inventory Tracker 1.0​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​
2​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​
3​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​	​
4​
5​
6​
7​
8​
9​
10​
11​
12​
13​
14​
15​

Sheet: Process

There are four buttons on the sheet namely:
Receive:
Issue Out:
Warehouse Transfer:
Stock Adjustment:

When the Receive button is clicked, I want it to open input boxes to get information into different cells with headers in the "Stock Movement(Receipt)". After the input boxes, I want a command button prompt that requests if the transaction is ready to be process. The command button updates the "Stock Update" sheet.