Copy paste loop using multiple tables

My request is a little more complicated than the title suggests.

Basically:

I have a list of employees in table 1 under column A.

I have a list of dates in table 2 under column A. I have a list of Types in table 2 under column B.

Finally I have an empty database for table 3

So the database would be Name = column A, Date = column B, Type = column C

I want to copy the employee name from table 1 and the first date from table 2 and put it into table 3. Then the same employee with the second date and so on until the last date is reached. Note, the Type is always the same (for the purpose of this routine)

Then copy the second employee, first date, second date etc and repeat until all employees have been copied.

table 3 should look like this:

EmployeeA Date1 TypeA
EmployeeA Date2 TypeA
EmployeeA Date3 TypeA
EmployeeB Date1 TypeA
EmployeeB Date2 TypeA
EmployeeB Date3 TypeA
.....
EmployeeF Date1 TypeA
EmployeeF Date2 TypeA
EmployeeF Date3 TypeA

etc........

Thanks in advance

Andy