how to Merge specific files from list .xlsx OR .csv or what ever the extension is

[Summer7sun]

1: I have two folders in desktop named "Today" and "Destination" path is (C:\Users\Work\Desktop\Today) and (C:\Users\Work\Desktop\Destination
2: both the Folders have multiple files with same name eg : Apple.xlsx OR Apple.csv , mango.xlsx OR mango.csv , Sheet names are same as file name. eg: sheet name for apple.xlsx is apple
3: files have data from a to z column and may expand to aa or zz
4: I have another file name Master and it has a sheet name as Master, It has a list of file names starting a7 eg a7 has Apple , a8 has Mango




I want a macro to merge or copy paste the values from the today folder to destination folder eg Apple.xlsx to Apple.xlsx and Mango.xlsx to Mango.xlsx ( Destination and the today folder files have headers so while pasting or merge just want the values added without the header
Also want the code to end the macro if the cell is "" in Master sheet List Range) Files in today folder has latest data which i want to merge to destination folder files, want the macro to work on only specific files that is from the list, names in list dont have the extension added ..... Please help

 

[Fluff]

Continuation https://www.mrexcel.com/forum/excel-questions/1045963-how-combine-only-specific-files-list.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).