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