Macro to copy data from multiple sheets to overview and align results on overview sheet

Hi all,

For my work I have created an overview of zipcodes which is created by combining multiple zipcode lists. The number of data to combine was small at first but now I'm looking at thousands of zipcodes, so I'm hoping someone can help me out as I'm a macro n00b

What I am looking for is some way to copy the data on sheets 2, 3 and 4 to sheet 1, the overview sheet, and align them so that equal zipcodes are aligned in 1 row on the overview sheet. I added an example work book.

I found a macro that does this here , but I am clueless on 1. how to edit the macro to fit my work book, and 2. how to transfer the AlignKeys macro to my work book.

I added an example to clarify.

Any feedback is very much appreciated!

McBree

Thank you so much for your response and solution ARowbot, this is Perfect!

McBree