Combine workbooks

Hi there everyone.

Every day at the office, we need to combine several workbooks into one master workbook. I have a script that does this; however, I would like some modifications to it.

For example, in a folder, I have three workbooks: Flowers.xls, Chocolates.xls, Stuffed Animals.xls. All three workbooks have two sheets each: Cost and Volume. The script creates a new workbook which has six sheets: Flowers, Flowers (1), Chocolates, Chocolates (1), Stuffed Animals, Stuffed Animals (1).

I would like the script to automatically rename the tabs in the new workbook into: Flowers Cost, Flowers Volume, Chocolates Cost, Chocolates Volume, Stuffed Animals Cost, Stuffed Animals Volume.

Any help with this would be greatly appreciated. Attached is the original script for your reference.

:-)