How to copy people names on A column on about 100 tabs to summary tab?

[Nuutti]

Hi!

I have a bit more than 100 tabs in my Excel workbook. All have peoples names in A column. Can I copy with some formula or script names of all those tabs to new Summary tab? Some names may appear on several tabs. I do not care if those names come to Summary-tabs several times. I can later on remove all duplicates.

Thanks in advance for your help!