I have 12 months of dealers information on 12 seperate tabs with 14 columns
for each dealer. I would like to create a master list where serching by
dealer number will add each column for each month.

I've tried adding vlookups for each sheet and gave me problems.