Copy columns from different sheets, into one

Hello all,

I have a simple problem and it seems i just can't make it work:

- i have one workbook with 3 sheets. in sheet 2 and 3, on column A i have a list of names, starting from A11 on both sheets.
- i need a VBA to copy column A (starting A11) from Sheet2 to sheet 4 (starting from A2) and column A (starting A11) from sheet3 to sheet 4 column A, starting from the point where the dates copied from sheet2, ends.

The VBA that i made can copy the first part correctly, but only copies the first row from sheet3.
I have attached an example

Please Login or Register  to view this content.

Thank you

Thank you both for your answers.
Both your solution are working just fine.
Thanx