Need help building formula(s) to share data between Sheets IF something is entered certain Column

Visitor

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. 

0 Replies