Vba code to extract data from one sheet to another

Hello all excel experts,

In sheet1 i have row data and sheet2 having output data actually i required a macro which should extract data from sheet1 to sheet2, in sheet2 column A(Name) data should extract from sheet1 from column A(Path) and date
in sheet2 column B(date) data should extract from sheet1 from column A(Path) and Mobile# in sheet2 column C(Mobile#) data should extract from sheet1 from column B(FileName).

Please find the attached sample file

Regards,

Xlhelp7