I need to import 3 excel files with different columns/rows into Stata.

Excel #1 looks like this:

Code:
Date StockCode SharesRepurchased
1-1-2015 US10 40
1-1-2015 US30 10
2-1-2015 US20 30
2-1-2015 US40 40
2-1-2015 US50 40
2-1-2015 US10 10
3-1-2015 US20 20
4-1-2015 US20 10
4-1-2015 US30 10
Excel #2 looks like this:

Code:
Date US10_Price US10_Volume US20_Price US20_Volume US30_Price US30_Volume US40_Price US40_Volume US50_Price US50_Volume
1-1-2015 300 6000 200 8000 100 7000 150 6000 300 8000
2-1-2015 500 4000 400 5000 300 3000 350 6000 800 7000
3-1-2015 200 7000 400 3000 200 2000 350 5000 700 3000
4-1-2015 100 8000 600 3000 300 6000 250 4000 200 5000
Excel #3 looks like this:

Code:
Date US10_Value US20_Value US30_Value US40_Value US50_Value
1-1-2015 0 0 3 0 4
2-1-2015 0 1 0 0 4
3-1-2015 0 3 0 4 0
4-1-2015 4 0 0 0 0
I need to run a regression on these variables, and in order to do this I think I need a Stata file like this:

Code:
StockCode Date SharesRepurchased Price Volume Value
US10 1-1-2015 40 300 6000 0
US10 2-1-2015 10 500 4000 0
US10 3-1-2015 0 200 7000 0 
US10 4-1-2015 0 100 8000 4
US20 1-1-2015 0 200 8000 0
US20 2-1-2015 30 400 5000 1
US20 3-1-2015 20 400 3000 3
US20 4-1-2015 10 600 3000 0
US30 1-1-2015 10 100 7000 3
US30 2-1-2015 0  300 3000 0
US30 3-1-2015 0 200 2000 0
US30 4-1-2015 10 300 6000 0
US40 1-1-2015 0 150 6000 0
US40 2-1-2015 40 350 6000 0
US40 3-1-2015 0  350 5000 4
US40 4-1-2015 0 250 4000 0
US50 1-1-2015 0 300 8000 4
US50 2-1-2015 40 800 7000 4
US50 3-1-2015 0 700 3000 0
US50 4-1-2015 0 200 5000 0
How can I convert the excel files such that I can get a Stata file like this? Also, in reality Excel file #2 contains too many variables, so do I need to split this excel file up?

Thank you for your help in advance