Automatically transfer data from one worksheet to various others

Hi,

I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) are filled in, TFS from worksheet 1, is filled in.

1.Worksheet 1 contain the following table headers:
Case Number,TFS,TFS Status / Case Status, Priority,Subject,Asset Name, Company,POC,Date/Time Opened,Closed, and Notes


2.Worksheet 2 contains the following table headers
Case Number,TFS/Task ,TFS Created On,TFS status / Notes

For example when I enter a number under the column TFS on worksheet 1 the TFS number along with the rest (case number, TFS Status, Notes ) is transferred over to worksheet 2. Every time the transfer occurs Excel should input the current date for each "TFS Created On" cell.

Thank you for helping me with this :)