Macro to copy paste from a different workbook

[ljuarez]

I have two workbooks. I need to copy a row from workbook A and paste it 17 times on workbook B and repeat this until I've gone through all the rows in workbook A (approximately 480 rows).

Steps:
1) I need to copy A1:E1, A2:E2, A3:E3....A480:E480 from workbook A to workbook B.
2) On workbook B, column F will be the product of E x 17
3) I will need to insert a column after E. This column will have the dates from 9/1/14-1/1/16

This is a sample from workbook A cells A1:E1

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]$2,000.00[/TD]
[/TR]
</tbody>[/TABLE]


I need the output to look like this on workbook B

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]9/1/2014[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]10/1/2014[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]11/1/2014[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]12/1/2014[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]1/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]2/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]3/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]4/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]5/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]6/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]7/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]8/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]9/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]10/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]11/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]12/1/2015[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
[TR]
[TD]651-631F[/TD]
[TD]A631F-CP[/TD]
[TD]A631F-CPMGFEE[/TD]
[TD]651-MGMT FEE[/TD]
[TD]1/1/2016[/TD]
[TD]$2,000.00[/TD]
[TD]$34,000.00[/TD]
[/TR]
</tbody>[/TABLE]






























































I then need the macro to go back to workbook A and copy A2:E2 and copy it 17 times like above, and keep repeating this all the way to row 480 on workbook A.

Right now this is a manual cut and paste process. I have two other workbooks I need to repeat this process on.

Thanks,

Luis