Excel VBA Code Automation

Job ID: 32841389

Budget: $10 – $30 USD

need some VBA automation, open a file with an inserted path (in a cell)
copy everything there and copy into a new sheet - creating a header (left ) line from a cell value

saving that file with that call value as a name

furthermore I need the code line by line explained

files will be provided