Auto Populate record from one sheet to another [Closed]

Report
Posts
3
Registration date
Friday January 22, 2016
Status
Member
Last seen
January 29, 2016
-
I'm working on a commissions spreadsheet for my company. There is a separate tab for each sales rep as well as the Sales Director. For every record I enter for a sales rep, the same record needs to appear on the Sales Director's sheet. Is there a way to have a record automatically copied to the Sales Director's sheet when it's entered on a sales rep's sheet? It would need to populate the next available row on his sheet throughout the month.