Copying Column from separate tabs in same worksheet into another worksheet with each colum

Please assist with a VBA Code
I have 10 tabs in a workbook, the first five tab is for 5 Departments for the Month of March, the other 5 is for the same 5 departments for the Month of April.

I want to compare a particular field for each Department for the two months. The field is in column N.
Is there a code that will copy column N for Finance March, Column N for April and paste them into another worksheet in the same workbook in Column A and B, then go to the next department HR and copy Column N for HR March and April and paste in the same worksheet where Finance already as in column D and E, then go to Operations March and April tabs and paste into the same worksheet as column Worksheet G and H.

Basically the copied columns are pasted March April next to each other for all the businesses in the new

Thank you for the help

Would this do? Try it on a copy of your workbook just in case.

Please Login or Register  to view this content.