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?