Hi i am looking at a macro that will copy all the worksheet ( same format) into 1 worksheet. All the .xls are in the same folder.

Thanks