Get data from one masterfile to different files

[markusvirus]

Hi experts,

I am looking to see if anyone can help me writing down a vba code to achieve the following:

- I have a masterfile named "RAW.xlsx" which I update by adding data daily
- I have other files to transfer the data to depending on the value in column P "Team Lead"(RAW file), and column P "Team Lead" (RAW sheet in File 1)
- I also have named ranges "account", "duration", "dept", "name", "task", "region" and "team" which I want to update automatically when I add data to RAW file

I attached a sample of one of the other files where I want to put the data to from RAW file.