update "master sheet" with project name, date, owner

Dear,

Could anyone help me out? I have a master overview sheet which I would like to update using vba :

cell C6 needs to be updated with the project name ( which can be found in input workbook sheet "Report Navigator" cell B1)
cell C7 needs to be updated with the creation date ( which can be found in input workbook sheet "Report Navigator" cell B3 until value AM or PM : Created on May 15, 2013 at 5:25:50 AM for John Smith)
cell C8 needs to be updated with the owner ( which can be found in input workbook sheet "Report Navigator" cell B3 after value "for")

Thanks a million in advance to help out here!

Rickmeister

the first request with project name is solved :

NewWorkbook.Worksheets("Overview").Range("C6").Value = ImportWB.Worksheets("Report Navigator").Range("B1").Value


still trying how to do a substring...