Merge Ranges add-in is an user defined function for Excel 2007/2010 (32 bit OS) that lets you merge multiple ranges into one master sheet in Microsoft® Excel.

This add-in is unlocked, you can view and edit vba code.

Features
Master sheet is instantly updated when values in a range are edited/added or deleted.
Possible to merge up to 255 different ranges (Excel 2007).
Easy to use custom function.
Get all data from all ranges.
Column headers in master sheet selects what column data to merge.
Blank records are not added to master sheet.
BONUS: Fetch unique distinct records or values from all ranges.
BONUS: Filter duplicate records or values from all ranges.