[Excel 2011]:Writing from one Excel file to enother- Dynamic way

[Hashmelator]

Hi all,
I have one file that contains three rows of information (Plz see the attached file) and I want to copy each row to a different file. Each row should be copy to a certain file that his name is located in the first file in row D.
In the end I expect to find the original file with addition of 3 files with data: File1.xlsx, File2.xlsx, File3.xlsx.

Is there an option in VB to do it like that?
Thanks in ahead!