macro to copy/paste multiple files with changing data to main XLSM file

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

Workbook named "301 CODE & OTHER STATUS.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 "HRT 301.xlsx" - data file will change daily
workbook named "RAC 301.xlsx" - data file will change daily
workbook named "FOS 301.xlsx" - data file will change daily. i have several more this is just a sample list of file names

copy from each individual file HRT 301 all data in file, paste into 301 CODE & OTHER STATUS.xlsm file into column B

STEP example:
go to file HRT 301.xlsx select all data from A2:M
go to file 301 CODE & OTHER STATUS.xlsm paste in column B
go to file RAC 301.xlsx select all data from A2:M
go to file 301 CODE & OTHER STATUS.xlsm paste in column B below the data from file HRT 301
go to file FOS 301.xlsx select all data from A2:M
go to file 301 CODE & OTHER STATUS.xlsm paste in column B below the data from file RAC 301

never mind! I got it resolved. thanks.

hi, conjohn ,may you provide your solution ? maybe other members take advantage from your solution
in the future