Linked excel sheets

We add data into the RWN MICS file (employees, sales companies etc) as well as the RWN BDM file (what commission our company, sales companies and our sales consultants receive per project) – this is only done once a new employee starts or new projects get releasedWe input data into the RWN DEAL PROGRESSION – Master file on a daily basis with a row per [login to view URL] data is automatically added to the RWN ACCOUNTS file (the main file! From which all others get their data)In the RWN CLIENT CARE – Master file dates are added to certain columns, which it automatically adds into the ACCOUNTS fileThe RWN ACCOUNTS file automatically adds its data to the RWN SALES CONSULTANT – Master file and RWN SALES COMPANY – Master fileThe RWN SALES CONSULTANT – Master file creates individual files for each employee with their individual deals and payThe RWN SALES COMPANY – Master file creates individual files for each employee with their individual deals and payThe RWN CLIENT CARE – Master file creates individual files for each employee with their individual deals and pay   --------------------------------   There are a few things currently not working correctly and need fixing (files attached):   RWN SALES CONSULTANT – Master file If data is updated in the RWN ACCOUNTS file in column AG, it is not calculating the correct figure in column U in the RWN SALES CONSULTANT – Master file. See examples highlighted in red in columns AG and U respectively! RWN ACCOUNTS cell AG668 -> RWN SALES CONSULTANT – Master cell U382 (Akhmed Hussain)RWN ACCOUNTS cell AG1207 -> RWN SALES CONSULTANT – Master cell U687 (Deepak Deshpande)RWN ACCOUNTS cell AG1255 -> RWN SALES CONSULTANT – Master cell U714 (Tom Butcher)Seems to work correctly: RWN ACCOUNTS cell AG85 -> RWN SALES CONSULTANT – Master cell U33 (Rishi Kumar Bawa)   RWN SALES CONULTANT - User files In certain RWN SALES CONSULTANT – User files such as Liam file, the hidden cash bonus tab is not updated correctly. I had to create new ones and now they are updating again but still don’t know why some are working and others aren’t Please see newly created correct file and old not working file!If I create a new RWN SALES CONULTANT – User from the RWN SALES CONSULTANT – Master file, everything gets created fine. But if I save and reopen it asks me to enable macro. If I do this all dates show as American!   RWN NETWORK CONSULTANT – User file The RWN NETWORK CONSULTANT – User file such as Sami file, gets created from the RWN SALES COMPANY – Master file. Column N and R need different calculations: column N: Please can you change the calculation is this column as follows: (column J in this file) * (column G * column H in the BDM file on the 'Sales Companies' tab) based on the project in column H in this file and column F in the in the BDM file on the 'Sales Companies' tab. If in the BDM file on the 'Sales Companies' tab, column G * H = 0, please use the amount in column [login to view URL] R: Please can you change the calculation is this column as follows: (column J in this file) * (column I * column J in the BDM file on the 'Sales Companies' tab) based on the project in column H in this file and column F in the in the BDM file on the 'Sales Companies' tab. If in the BDM file on the 'Sales Companies' tab, column I * J = 0, please use the amount in column L.   -------------------------------------------   Here are the new things we would like to add:   RWN SALES CONULTANT - User files In the RWN SALES CONULTANT – User file such as the Liam file, which gets created from the RWN SALES CONSULTANT – Master file, there is a CASH BONUS tab which is hidden (because it shows the data from all employees from the RWN SALES CONULTANT – Master file). What we would like is that the CASH BONUS tab is not hidden and instead only shows the relevant sales consultants cash bonus entries and no one else’s.