Maybe this add-in will help

http://www.rondebruin.nl/merge.htm

VBA Noob