Copy sheets from multiply workbooks into one file.

Hi, first time posting...



I have a list of different customers (they all have a file saved) and need to bring the sheet from the customer file.

I have got a macro that creates new sheets from the list, and now I need to import files using the sheet name, (this will match workbook name, saved in C:/Customers/)

Please help

Thanks