Summary of a workbook that new worksheets will be continually added.

**OREGFARR** · 09-17-2012, 07:36 AM

hello! I hope someone could solve my problem.

I have created an excel workbook and will be inserting worksheets as needed. Each worksheet will have a unique name and the format will be constant.
problem: I need to create a summary worksheet that will copy data from each worksheet. The data is in the same location for every sheet as column G5 through G27. I need the data to copy across columns for each tab. Each row should contain the data from each tab.

I hope someone can help.

Thanks,

OREGFARR

**arlu1201** · 09-17-2012, 07:49 AM

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**Pepe Le Mokko** · 09-17-2012, 08:02 AM

Have a look at this addin to get you on track

The code is also available so you can tweak it if needed

**OREGFARR** · 09-17-2012, 03:23 PM

Hello I attached a copy of the workbook. The Index Tab reflects an example of the end product after the data from worksheets that are continuoulsy added should look like.

Thank!