Compare column names and copy data from several sheets only where column exists else blank

[henste1967]

Hello absoute beginner at VBA!

I have a spreadsheet where I would like to copy data from tabs ATPMD, STPPMD, and SBMD to tab Core, I would like the code to copy in row data where the column name matches on the above tabs.

Thank you so much