Automatic updating of a rollup worksheet when a new worksheet is a

[Guest]

Background:

There is a "rollup" spreadsheet that contains a high-level look at

different projects that are going on.

Each project is on it's own worksheet in the same workbook as the rollup worksheet
All project worksheets are formatted exactly the same way and

contain exactly the same types of data

The data on the rollup spreadsheet is pulled from all of the project

worksheets.

The Problem:
When a user adds a new project to the workbook (essentially adding a new
worksheet), how do i get the rollup worksheet to update automatically with
the information from the new worksheet?

 

[Otto Moehrbach]

Basically you would loop, with VBA, through all the worksheets in the file,
skipping any worksheet not pertinent, like the "rollup" worksheet. Within
this loop you would check if the sheet name is already in the rollup sheet
and if not, add it. Then copy all the things you want copied. Please post
back if you need more than this. HTH Otto