How to Send values ​​to another sheet by skipping column

hi all,
I am still perfecting the code that I get in this forum, the code is to 'send value between the sheets'

Please Login or Register  to view this content.

how it works is
SOURCE

B C D E F
3
4
5

Cell source = B3: F5

Cell destination= next empty row based on value in sheet SOURCE range B
if at first the code is running as
source--> destination
D---------> D
E---------> E
F---------> F

How to modify code if cell destination skipped over two columns
source--> destination
D--------> D
E--------> E
F--------> H
Is all of above code should be changed for that goal?
Thanks in advance

hi xladept..
Yes correct ..destination sheet name = value in range B ( sheet source)

with it we can send data to multiple sheets at once CMIIW

I appreciate it
I also tried modify the code

hi xladept,
In workbook in sheet "Destination" the 'numbers 5' with the above code is located in column "F", I want to jump to the column "H" (skip column "G" )... by modifying the above code