I need help. I have a spreadsheet where I have a main tab that contains all master information. I then want to create a formula or rule that copies certain cells to other specific tabs in the workbook based on rules.

Example: If there is no data in column D it should be copied to Sheet 1. Once data is entered in column D it gets moved to sheet 3.

Please help, thank you!