Copy paste columns if criteria is met

I'm having problems trying to get my code to work and I need some improvements to it as well.

I need to copy and paste all the values in the Source worksheet ("Totals") to the destination worksheet ("Monthly Overall"), but only if the column headers (which are date values) in the source worksheet ("Totals") match the destination worksheet ("Monthly Overall") column headers (which are dates as well). I would also like it, if it could verify, before copying, that the order of the list of names match in both worksheets, if it doesn't match then don't copy.

Another issue is that I have three sets of tables within the Source worksheet that need to be taken into account, so I'm not sure what's the best way to go through all the data ranges and copy them to the destination worksheet if the above criteria (s) are met.

My initial approach was to look at the column dates and if they match then copy and paste the column to the destination worksheet that matches that date value.
Here is what I have so far, please help, I'm new to VBA and this code is not working for me:

Please Login or Register  to view this content.

FYI: The reason why I need this is because the source data will be changing and I need to keep a record of that data.

Thank you for your response but unfortunately that will not work for me. I have updated the file, unmerging the rows with the names and I have updated the "destination worksheet ("Monthly Overall"), to probably make things easier. Hopefully you can still help me. If the order of the names canīt be checked before copying and pasting the data, I can make it work if the code transfers the data to the column header dates that match the Source column header date.

Thanks

@Jindon

Good catch...didn't notice that...

Note : Dates in Week 10 & 11 are identical in your file.