Extract Worksheet Title/Refence

[Ludim]

I have a huge list of worksheets, I need to check that I have captured them
all against our product list. Is there a way to extract every worksheet to
make a list and compare?

 

[Shane Devenshire]

Hi,

So you have 1 workbook with a huge number of sheets and you want to workshet
titles and references? What does worksheet references mean?

To extract the name of all the sheets in a workbook to a column A in sheet1
use a macro

Sub mySheets()
I=1
For each sh in Worksheets
Range("A1").Offset(I,0) = sh.Name
I=I+1
Next sh
End Sub

(untested)