I need sub procedures to run in Excel 2003 when a new sheet is added / copied
from another workbook but nothing is happening. I'm not a VBA expert and not
understanding what I need to do to accomplish this. I have code that reads
info from each new sheet that represents monthly sales data and compiles
stats into a summary sheet1. When a new sheet is added to the workbook I need
that code to run immediately so it updates the summary sheet. If anyone could
give me a clue that would be great.

Thanks