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

Alan

Firstly thank you so much for your time, I ran the code, it ran and left me on tab SBMD but no data was in Core, maybe I am doing something wrong, I received a message saying it was complete but no data.

Thanks again.

Steve