Macro that copy/pastes from multiple workbooks to one workbook

All files are already open. I need a macro to copy and paste the data only.

workbook named "ALL data.xlsm" - main file that holds macro. all data from individual files below need to be pasted here. Column A will be a formula. New data from files listed below will be pasted into column B. Append do not copy over each other.

workbook named "AND.xlsx" - data file will change daily
workbook named "BAJ.xlsx" - data file will change daily
workbook named "FOS.xlsx" - data file will change daily. i have several more this is just a sample list of file names

copy from each individual file AND all data in file, paste into ALL data.xlsm file into column B

STEP example:
go to file AND.xlsx select all data from A2:N
go to file ALL data.xlsm paste in column B
go to file BAJ.xlsx select all data from A2:N
go to file ALL data.xlsm paste in column B below the data from file AND
go to file FOX.xlsx select all data from A2:N
go to file ALL data.xlsm paste in column B below the data from file BAJ

You should be consistent with your file names and what you upload for sample files. The code uses the names of the uploaded files, but you can change those to the actual file names.

Please Login or Register  to view this content.

Yep, oversight on my part. Here is amended code.

Please Login or Register  to view this content.

Originally Posted by conjohn562

SUPER! thanks!

You're welcome,
Regards, JLG