Open list file and copy sheet

[matrix_xrs]

Hi,

i'm hoping someone here can give me some directions with a macro i'm trying to create

I'm trying to create a macro that will look at a list of files open the first one and then search the sheet names and if the sheet names matches the file name copy the sheet to the opened file.

example:

file 1:
sheet1 Contains a list of file name and path
sheet2: apple
Sheet3: banana
Sheet4: car


macro will open first file in list and lets assume it is called apple.xlsx

it will open file and then search file 1 sheet name and if there is a sheet called apple it will copy the sheet to the opened file.


it will continue doing this until the list is complete

fairly new to macro and need some directions as to how to complete this. any help is greatly appreciated

attached a file for sample

thanks a million