Excel Coding

We have an existing tool for audits that we use to which we are trying to add another minor functionality. What we are looking to do is the following: A. Whenever data is populated in the "Sample Selection Rationale_Empl" tab, the data should automatically get populated in the "Employee Tracking Tab" in the following format: 1. Employee First Name and Last Name (this is two separate columns) Employee Title Date of Hire There would be 20 employee samples which would have the same format and should be aligned properly in the "Employee Tracking" tab. B. In the "Employee Tracking" tab, cells A22 and 23 should have a similar structure as mentioned above. The data for these cells are coming from the "sample Selection Rationale_Trac" tab. The data should be copied to the "Employee Tracking" in cells A22 and 23 in the following format: 21. Name of the FTE (taken from "Sample Selection Rationale_Trac" tab Cells B7 and B28) Component ( (taken from "Sample Selection Rationale_Trac" tab Cells B9 and B30) Since the project is fairly simple the turnaround time is fast (possibly by today). The audit tool will be provided in which these functions need to be added.