How to use macros/VBA in Excel to copy/paste 3 portions of a large column of a workbook to a specific position in another workbook?

I am very new to VBA (know next to nothing about how to code in it) but have a basic understanding of how coding works. I am curious if anyone could help me with a script idea I have to automate something I am working on at work.

Basically, there are 2 types of spreadsheets: around 60-80 unique spreadsheets for the data collected for each sample, and 3-4 large spreadsheets that contain transferred data and uses algorithms to draw conclusions about them. The large spreadsheets have 10-20 tabs(different worksheets), each for a different sample.

I would like to be able to make some sort of Macro or VBA script that allows me to automatically copy and paste (transfer) 3 specific portions of a column from the sample spreadsheets (each one has the important data in the exact same cells in the exact same column. It's basically like 200 numbers in a column are important, then it skips ahead 200ish, then the next 200 numbers are important, then skips 200, then next 200 are important, but this is just an approximate number) and bring them over to a certain part of the large overall spreadsheet.

If this is possible to do and anyone could help me out in making this happen, it would be an immense help and greatly appreciated. Thanks!

Recent Questions...