Add cell value to existing tab name - VBA

I've searched the existing threads, but haven't been able to find a solution that will help me. I apologize if I've missed it, and please point me in the right direction!Invoice Example.xls

My situation is as follows: I have multiple workbooks that each contain three worksheets, the worksheets from one or more of these workbooks needs to be added to another workbook.

Since the worksheet names in all workbooks are the same, I need to add the data from a cell (account number) in the file to the existing worksheet names. Using the attached file as an example, the value of cell A8 on the DMC-UPS-Summary worksheet needs to be added to each worksheet name in this file.

Thanks for any help that you can provide!

Diane

Thank you for your speedy and wonderful reply TMS! This works perfectly! I hope that you have a wonderful weekend.

Diane

Thank you for your speedy and wonderful reply TMS! This works perfectly! I hope that you have a wonderful weekend.

Diane