Consolidation Values only

Hi All,

I need a macro which can consolidate the data from all the sheets in file and gives master sheet in same file.
(Master file should have only values ).

Thanks,

Hi ravichandavar,

This is what you are looking for

http://www.excelfox.com/forum/f13/co...-file-vba-569/