Glad I could be of help.
--
Gary''s Student
gsnu200709


"Philip" wrote:

Brilliant! Just what I was looking for! And I didn't even have to ask the questions. Thanks.

Philip

Gary''s Student wrote:
Here is part of your answer. Enter the following macro, then select some
cell and run the macro. It will produce the list of worksheets at the point
you selected:

Sub sheet_lister()
i = 0
For Each w In Worksheets
Selection.Offset(i, 0).Value = w.Name
i = i + 1
Next
End Sub