Hi all,

I'm having trouble figuring out how I would get all of the worksheet names in 1 workbook, copying and pasting them into cells in another sheet in that same workbook.

Example:
Sheet1 = Apple
Sheet2 = Pear
Sheet3 = Banana

Code would make extra sheet at end called "List" and would have cell values:
A1 = Apple
A2 = Pear
A3 = Banana

Please help? Thank you!