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.

:-)

Okay, attached are several dummy workbooks (Flowers.xls, Chocolates.xls, and Stuffed Animals.xls) and the finished product of the script I am using (Combined Workbook.xls).

Thank you for your help.

:-)

Wow, it works perfectly. You are incredible. Thank you so so much. I am reviewing the script now.

Is there any way I can pay you back? Barring actual currency and/or sexual favors.

:-)

Hi again, and thanks for all the help so far.

My problem now is: what if I want to combine selected sheets? The dummy workbooks I attached have only two sheets each: Cost and Volume. What if they had three sheets (Cost, Volume, and Date) and I only want two specific sheets (Cost and Volume) in my combined workbook? Is there a way to modify the script so that this is possible?

:-)

I have the issue temporarily solved with a hotkey (LOL) that unprotects the workbook and deletes the offending (!) sheet.

Any further assistance would still be appreciated.

:-)