You can write code to copy that data for new sheets, but there is no delete
sheet event so you cannot trap that.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"tjennings" wrote in message
...
I have a workbook with numerous tabs/worksheets...I have created a summary
sheet that links to each worksheet.
First of all I would like to produce a list of all the tabs in the
workbook
to verify that i have included every sheet. I know this is a bit archaic
but
I want to start here.
Secondly, I would like to know how to create a new sheet that will
automatically detect each tab, list the tab names in a single row across,
and
pull specific data from each tab.

I am not proficient with excel macros or visual basic...but i can folow
simple instructions easily.

here is a simple example of what I would like to do:

Sheet 'A'
Price 150
Estimate 200
Recommendation Buy

Sheet 'B'
Price 250
Estimate 200
Recommendation Sell

Sheet 'Summary'
A B
Price 150 250
Estimate 200 200
Recommendation Buy Sell

I want the summary sheet to automatically update if I add a new sheet, say
'C'
The data it will be looking for will be in the same cells of each sheet.

I know i can do this by just inserting columns and copying the links
formulas from the adjacent cells...however, the workbook is constantly
updated, and new sheets added and deleted frequently...I would rather if
there was someway to update the summary sheet automatically.