Copy a sheet name to another workbook

[Scoobster_doo]

Hey Guys,

I'm looking to copy various sheet names to cells in a different workbook.

I understand there's a way to copy into the same workbook i.e.

Please Login or Register  to view this content.

however I want to capture multiple always changing sheet names and paste/array them into a different workbook as a list.

I.e.

Workbook A Sheet Names:

A B C 1 2 3 (Where ABC are always the same and don't need to be captured)

Workbook B:

Add sheet names 1 2 3 to column A in Sheet 1.

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Scoobster_doo]

Absolutely Spot on!

Thank you

[bakerman2]

If it's a large number of sheets to list.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and the rep.