Hi All, this is my first time posting so I will try to be as detailed as possible.

I am very new to VBA and am trying to make a macro that can do the following for 50+ identical workbooks with different cell values and combine data in their respective columns:

1. fill a cell with filename
2. Copy A1:B2
3. Copy J6:J95, M6:AI95

I have had luck with youtube demonstrations for copying columns, however I am stuck trying to copy all these at once :(

The end result I am hoping for is something like this:

A1(File name)
A2:B3 (Copy of A1:B2)
C1:Z89 (J6:J95,M6:AI95)

Then after this data,the following workbook copied would start at A96...

Also, copying of just the values would be best and not their original formulas.

Thank you very much!!