I have three worksheets: CurrentUpdates, YTDUpdates and
Account_Info_Master_Sheet.

One a monthly basis, new account information will be entered into the
CurrentUpdates sheet. I would like the data field from this spreadsheet
(Account Name, AE, Region, etc) to auto-populate at the bottom of the
YTDUpdates sheet.

Also, not sure if this can be accomplished, but I would like the
CurrentUpdates sheet to automatically make any changes to the
Account_Info_Master_Sheet or add new data (depending on the scenario).

I'd like to keep the CurrentUpdates sheet clean, so that once additions are
entered, they are either hidden or deleted from this sheet.