Move different sheets from different files to one file

[aravindhan_31]

Hi,

I have 6 excel files in one folder named as
FileX, FileY, FileZ, FileA, FileB & Master file
each file excel Master file has different sheets
Say File1 - SheetA, SheetB, SheetC etc
File 2 - Sales, Data, Profit, Loss Etc
File 3 - Country, City, State, Etc
File 4 - Company, Address, contact etc
File 5 - Employee, Details, Transport etc

I have a master file where, I need to get sheets from the above 5 files
say, SheetA & SheetC from File 1
Sheets Sales & Loss from File 2,
Sheets Country City & State from File 3
Sheets company, Address and contact from Sheet4
and Details & Transport from File 5

All these sheets has values driven by formulas, so when these sheets are moved to master file, all the values on those sheets should be just a values not a formulas.

If I do this manually, I open each file and move the sheets to this file.
I have around 25 files like this a

I would appreciate if someone could help me on this by a VBA code.

Arvind

[aravindhan_31]

Hi

The cross post is here:http://www.mrexcel.com/forum/showthr...=1#post1921248