Combine multiple "Named Ranges" from different workbooks into a new workbook

[Vinod Menon]

Hi,
I am currently working for a company which has multiple branch offices across the country.
An Excel template was designed by my earlier colleagues with multiple sheets (e.g. IncidentList, ExpenseList etc) which has dynamic named ranges (like PhysicalIncidents, InformationIncidents, LocalExpense, InterCityExpense, InternationalExpense) and shared to all the branches.

We receive a monthly excel file from all the branches which I need to consolidate and present to the Management.
I have prepared a Master Excel Workbook and copy all the files received into a common folder and use the RDBMerge Excel Add-in (http://www.rondebruin.nl/win/addins/rdbmerge.htm) to consolidate all the data. But I need to select a particular sheet (one at a time) and do the consolidation, copy to the Master template and the redo the steps for another sheet.

Is there any way to automate this process, can someone help me with a macro, wherein all named ranges are copied to different sheets with the NamedRange as the worksheet name.

Regards,
Vinod