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.

This is perfectly possible, but your question lacks a lot of detail.
Perhaps attach a couple of workbooks and be quite specific about where things are to be copied from and where things are to be copied to.

Also, since you're using Office 365, there may be better ways of getting data from several workbooks into one.

I note that you've also posted this question elsewhere, namely:
VBA Macro to copy non-adjacent cells to a different workbook | MrExcel Message Board
https://www.mrexcel.com/board/threa...jacent-cells-to-a-different-workbook.1172005/
VBA Macro to copy non-adjacent cells to a different workbook
https://www.excelforum.com/excel-pr...n-adjacent-cells-to-a-different-workbook.html

This isn't a problem by itself, but for your information, you should always provide links to your cross posts.
This is a requirement, not just a request. Many forums require the same.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

This is a bit weird, because the text of your message is remarkably similar to an 8 year old post at stackoverflow:
excel - VBA: Copying a cell range to different workbook - Stack Overflow
https://stackoverflow.com/questions/14811681/vba-copying-a-cell-range-to-different-workbook