Combine Excel files.

[TheVig]

4 files in a folder with sheets:

filename1="C:\01JAN10.xls"
sheet1="INCHES"
sheet2="PREPRNT"
sheet3="ADV"
sheet4="PGS"

filename2="C:\ILINCH11.xls"
sheet5="SUMMARY"
sheet6="COMP"

filename3="C:\ININCH11.xls"
sheet7="SUMMARY"
sheet8="COMP"

filename4="C:\TMC11.xls"
sheet9="SUMMARY"

I want to create a master file that has all of the sheets in one workbook and maintain the formatting in the sheets.
Is this possible? I know the sheets will need a unique name in the end...so could prefix filename to beginning of sheet name.
So the end result will be one file with all the sheets:
filename="c:/MasterFile.xls"
sheet1="01JAN10 INCHES"
sheet2="01JAN10 PREPRNT"
sheet3="01JAN10 ADV"
sheet4="01JAN10 PGS"
sheet5="ILINCH11 SUMMARY"
sheet6="ILINCH11 COMP"
sheet7="ININCH11 SUMMARY"
sheet8="ININCH11 COMP"
sheet9="TMC11 SUMMARY"

Really it's the part of maintaining the format that I don't understand....getting data from a specific sheet in a workbook has been covered several times. But how to copy data with formatting?

Thanks,
jimmy Vig