Hi

This is my first post so I hope I do it all correctly.

I have a workbook that has multiple worksheets. Each worksheet is labelled with a client name. Worksheets are added and removed on an ongoing basis.

I need to collate the names on a single worksheet which I will manually add other details to, sort of like an index?? I'd like it to be in the same workbook. I'm not sure if I can use the name from the tab but I could put it elsewhere in the worksheets which would be preferable as I could then have their full name.

Can anyone suggest how I could do this please?

Ddzigns