I have a Sponsor Excel Workbook, on the main Sponsors is where we would ender Sponsor name, address, phone # , email, and where and how much they would like to donate.
Each Department has its own column, and therefore it's own Sheet. I would like it to be where we just enter all information on the Main sheet and if an amount is entered in a Department column, then all that Info is added and updated automatically to the corresponding Sheet.
IE: IF an amount is entered in Column M, THEN Name, Address, Phone #, Email, and Amount donated is automatically added to the corresponding Colum M Worksheet.
I have attached the Workbook I am working for reference.