Matching 2 columns and sorting so they line up.

I have 2 large datasheets. Both contain a Postcode column. I would like to get both these seperate sheets to match up by postcode (since that is the only column which appears in both).
I know about conditional formatting which is all great, but how do I get the postcodes to match up and will sort the 2nd or 1st sheet by the postcode column so they all align?

For example, currently the postcodes on each sheet are:

column A from one datasheet, column b from another:

Please Login or Register  to view this content.

I would like the data to line up, arranging by other columns just so the post code matches up.

Please Login or Register  to view this content.

I hope all that makes sense.
I cant just arrange by postcode on both, because one sheet has more/less information than the other and if one list contains a single extra postcode, everything is thrown off. Hence this cry for help.

Hi

What I mean is, sheet 2 contains postcodes. Most, not all, are the same on sheet one but sheet 2 contains about 5 other columns. Sheet 1 contains 5 different columns also, the only thing similar in both is the postcode column.
I want to copy over all data from the 2nd sheet, I then want the 2 postcode columns to match up so all 10 columns have accurate information. I could then delete the extra postcode column as I will no longer need it. I can't really post any sheets here, due to the information it contains.

I do not know which sheet do you want to use to paste all columns plus if you want to clear the data in sheet1. The code pastes the data in sheet1 column c

Im not too bothered about pasting per se, I can do that part manually.
I am at work at the moment. Are you able to post what code is in the attachment so I can try it here?