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.