@crystalhi crystal, is that mean that there is no way the code will work when the workbook is closed? 

I got the error" Unable to get the PivotTable property of the range class". Do you know hoe can I fix this?

Great work... It's very helpful for me, thanks very much 

Excellent macro.
How can this be modified for my need case as below. I have zero experience in VBA.
The source folders (3 – zmf, vek, num) and destination folders (4 – jack, james, john, jane) names and paths are constant.
Source folders (3)
\\192.168.xx.x\ma\zmf\ (files here – 123.wav, 456.wav, etc)
\\192.168.xx.x\ma\vek\ (files here – abc.wav, etc)
\\192.168.xx.x\ma\num\ (files here – ghi.wav, etc)
Destination folders (4)
\\192.168.xx.xx\ba\jack\
\\192.168.xx.xx\ba\james\
\\192.168.xx.xx\ba\john\
\\192.168.xx.xx\ba\jane\
In Excel sheet, in Column A I have the list of files (will change on a daily basis) which have to be COPIED (not moved) to the folder in Column B (the folder in which the files are contained (zmf, vek, num) also have to be copied.
For example, 123.wav has to be copied to the folder “jack” such as \\192.168.xx.xx\ba\jack\zmf\123.wav
    abc.wav has to be copied to the folder “jane” such as \\192.168.xx.xx\ba\jane\vek\abc.wav
    ghi.wav also has to be copied to the folder “jack” such as \\192.168.xx.xx\ba\jack\num\ghi.wav
    
Column A    Column B
Files in Source folders    Destination folders (constant)
123.wav    jack
456.wav    james
789.wav    john
abc.wav    jane
def.wav    james
ghi.wav    jack

Can anyone ...

How to export all sheet names in open excel file to Google Sheet? Thank you 

How can I get this number reduced using formulas to make 3604000000157477 to be 3604157477 first 4 to the front and last 6 digits.

It doesn't work very well for me. It gives 0 pages for half of the files. Any idea why?

im looking for a formula that will compare 2 working dates minus holidays if the days are not 30 then return the first day of the next month. example if 10/4/2021 and 11/04/2021 are less then 30 days then 12/01/2021

I'm 63 years old. Have been looking for how to do this this (directory to Excel to with attributes) for years! Tried many methods so complicated that I had to learn new programming language (i.e. command prompt and command shell, I am subject matter expert, IT user; not dedicated IT). But thought it should be simple so kept looking. AND HERE IT IS!! So easy my now elderly brain gets it.  Thank you, thank you. Bless you! All hail extendoffice! You rock.