VBA Macro to copy non-adjacent cells to a different workbook

I am currently working on an integrated set of workbooks, where I need to transfer data values between workbooks. In order to do so I need a VBA Macro that can copy non-adjacent cells (ex. the locations of the cells are J4, J8, J12, J16....etc) and insert it in the other workbook with a different structure (ex. the space between the cells would be 4 instead of 3.)

This is my first time using VBA so I'm not sure if it's possible. I'm using Microsoft 365.

First according to any forum rules post at least a link for each thread on the same subject created on other forums …

I tried to post the link but it doesn't allow me and this massage appears.

You are not allowed to post any kinds of links, images or videos until you post a few times.