Macro to consolidate excel files in one database file

Hi,

Please help!!

My query is,

I want to prepare a database in excel. This is database of five different excel files.Consolidate them in one excel file under five sheets.

These files have name say A, B, C, D, E. Macro should ask user to browse these files one by one and copy data in new excel under individual sheet. Finally database should save as name X and should contain sheet 1 as A sheets 2 as B etc.

Please let me know in case of any query.

Thanks,

Also: www.ozgrid.com/forum/showthread.php?t=184792