Is there a way to write a command that will transfer the value of every "6th"
cell of a column in worksheet "A" to a contiguous column of cells in
worksheet "B"? For example the value in "A!B6" is transferred to "B!A1",
"A!B12 to B!A2", "A!B18 to B!A3" etc. etc. I know I can manually reference
each target cell in Worksheet A to transfer over to Worksheet B, but the
scope of this project is such that I would like to write a function/command
that can then be copied and pasted. A normal copy and paste is dynamic one
row at a time and I need it to reference every 6th row.

Sorry for the "less than eloquent" description of my problem.