Copy Sheet1 few column data to sheet 2 selected column

Dear Expert,
i want to copy sheet1 few column to sheet2 and sheet1 column copy range start from row 6 & will paste to sheet 2 selected column from blank row, like as sheet1 A column data will copy from A6 to all & paste will sheet2 column H & paste row will be start from blank (if any data already avail) .

column will copy/paste from sheet1 to sheet2 as below:
Sheet1 A=Sheet2 C, Sheet1 D=Sheet2 B, Sheet1 E=Sheet2 A, Sheet1 B=Sheet2 G.

Please help me in this regard.


Best Regards
Wahid

Thanks, your code is ok & working but need a small correction that data pasting always start from sheet2 column "A" blank row and other column data paste also start from this row considering A blank row. other column any cell can blank but data should paste from A column blank row.

Please help in this regard.

Best Regards
Wahid

Your first code is suitable for me & add my 2nd requirement with this code.

then its show me "Object required", please attend this.

Dear Expert,
Post 2 code mostly solve my problem, you just add post 4 requirement on post 2 code.

Thanks

Dear Expert,
I attached my document there i want to copy sheet1 to sheet2 belo column and always copy from A6 row for all column sheet1 and always paste from sheet2 a column blank row for all column.


sheet1 column=sheet2 column as below:
A=A
B=B
C=C
D=D
I=E
M=F
R=G

if sheet 2 A column has already data up to row 10 then my paste will start from A11 row and all data all column will paste from row no 11. that means paste row start depend on sheet2 a column blank row.

Thanks
Wahid

Dear Expert,
My problem is solved.

Thanks