The answer to your question is YES, you can do it using trigger. You will have to use the Insert trigger for this.
Code :
CREATE TRIGGER triggerName ON yourSourcetable FOR INSERT
AS
INSERT INTO yourDestinationTable
(col1, col2 , col3)
SELECT
'value1', 'value2', 'value3'
FROM inserted
GO
when you want to access the new record which is being inserted then the same can be accessed using system table name
inserted
. I have used this table only. So you can replace the names of the columns by your table's columns.
Hope this helps.
All the best.