Make a List from a table

I need to make a Combined Name List from several tables by formula or Macro code.

Attached file defined detail and what is exact wanted.

Thanks in advance for any reply and help.

Regards,
turist

Try this for results on sheet 2 columns "A & B"

Please Login or Register  to view this content.

Regards Mick

Dear Mick,
Great solution. Works.

Thanks for all kind help.

Regards,
turist

You're very welcome
Regrds Mick