wondering if somebody could help me out.

I'm after a VBA that will copy all the names from columns D, E & F in each worksheet and then create one master list in another tab.

Thanks in advanced...