Your syntax is wrong. You have all kinds of extra characters.
Keep it simple:
INSERT INTO newtable ([Todaydate], [Name],[LOCATION], [Type])
SELECT GETDATE(), t1.Name, t2.Location, t3.Type
from table1 t1
LEFT JOIN table2 t2 ON t1.Name=t2.Name
LEFT JOIN table3 t3 ON t1.Name=t3.Name