Hello all,

I have a spreadsheet that was given to me with 23 tabs, each tab has four columns (Hub, Address, City, Zip). What I have been asked to do is create a new tab within this spreadsheet that combines all the information from the 23 tabs, removes duplicate address's and gives me the number of times each address had been delivered to. Is there a way to accomplish this?
I have been trying to use VLOOKUP but not having much luck right now.
Any one have any suggestions?
Thanks,