Auto Populate (?) Question

[Gary Nightwagon]

Good Afternoon-

I created a survey with a summary page in MS Excel 2007. Each new worksheet contains an additional survey and data corresponds to a summary page dashboard. I'd like for data entered into a new worksheet to autopopulate a new column on the summary page each time data is entered into a newly created worksheet.

If this is possible, i'd greatly appreciate some help with this.

Thanks