Hi Jerry, you macro is very helpful. I have one quick question. what if I just want to combine all the files into one single work sheet ( a new file but all on one tab)?