Data from two sheets onto one new sheet using VBA

Hello,

I have data on two sheets. Sheet1 has data in column A. Sheet2 has data in column A. What I want to do is on sheet3 take each cell on sheet1 and place it column A repeating the cell value for as many rows as there are in sheet2. Then I want to have each value of sheet2 in column B of sheet3 next to the repeating value from sheet1. I am having a hard time describing what I want but if you take a look at the file I uploaded it is pretty explanatory. Thanks.