How copy people names (in A column) from about 100 tabs to summary tab?

Hi!

I have a bit more than 100 tabs in my Excel workbook. All have peoples names in A column plus some additional info in other columns. Some tabs have 20 rows while others may have up to 250 rows. How can I copy the names from all those tabs to new Summary tab? Some same names may appear on several tabs. I do not care if those names come to Summary-tabs several times. I can remove dublicates later, but if you have a ready script to gather those dublicate names only once, even better.

Thanks in advance for your help!

Thanks. This worked.

I faced another problem. Some of the entries on my summary are written in various ways, but I know they are the same. How can I pick out some names to different list that have some part of name I would like to replace or delete totally. These could be terms like eg. "Sr" or "SA" in the name. These extra words or parts of words may be in front, middle of end of name. I cannot just delete those terms straight away, because some real first or last names may contain those few letters.