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
"Marc A." <Marc wrote in message
...
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?