How can I get a worksheet name appear in a cell?

G

Gary

I have 199 worksheets and I would like to have a summary page that displays
the sheet name in column A . I'm looking for a script or how to reference
the worksheet name so I can have a function auto populate the table names
from A2..A200

Thanks
 
Top