Copy data from 1sheet to other sheet as per selected option

[jangir72]

Hi,
I have large date in sheet "CB" from Col A to Col AB
I want to copy them in sheet "Report" as per following options:
If Option selected:
Fill col. A to K from Row 4 of in "Report" with Columns shown below from Row 9 to empty row of "CB" :
(1st row in below table is Colums of "Report" and other rows are columns of "CB" )

A

B

C

D

E

F

G

H

I

J

K

L

Option 1

A

N

D

B

C

E

F

G

J

K

L

FORMULA

Option 2

A

R

D

B

C

E

F

G

J

O

P

FORMULA

Option 3

A

V

D

B

C

E

F

G

J

S

T

FORMULA

Option 4

A

D

B

C

E

F

G

W

X

FORMULA

Option 5

A

D

B

C

E

F

G

Z

AA

FORMULA

<tbody>
</tbody>

<tbody>
</tbody>

Then delete row if Col J + Col K = 0 in case of Option 1 to 3 and if Col H + Col I = 0 in case of Option 4 to 5

Sort Col B wise
Fill formula for running total (e.g. for Option 1 to 3 in cell L6 = L5+J6-K6; for option 4 and 5 cell J6 = J5+H6-I6

Fill column header in row 3 of "Report" from Row 8 of "CB"

Could somebody help me to solve it though Excel VBA.
Thank in advance
Warm regards