Need help keeping track of roster and its changes

[taylorsm]

I have a tracker that I use to track the audits of three teams. Right now the teams are on the same sheet together. I have three employees who audit the three teams. I assign one team to one auditor. My issue is how to keep up with changes in teams. If people trade teams then I have to update that. Right now each auditor has their own workbook (because shared wbs don't work well), I then run a macro that goes and copies their team (it only selects their team based on column "a") into my master tracker. I then push all that back out to everyone so that they have a copy of the master. This way they can see who needs help and such. So essentially, I combined into one, then push back out. My auditors will help each other if they fall behind or if one is absent, so its good for them to have a copy of the master. If someone changes teams then right now I can just change the team name on my master and it will get copied out to everyone. Not real difficult right now. My issue lies in that there always seems to be some discrepancy, either something doesn't copy or paste. The code below is what I use to pull all the data together. I'll make a second post on how I push the data back out. I am looking for a better way, its multiple times a week that sometime needs changed and it never seems to go smoothly. I think I can manually copy the data faster than w/e I did wrong with the code. I attached a sample workbook. If you want 100% similar testing then duplicate that workbook for each QA name, and one for the master.

[taylorsm]

This is the error I get when trying to post the macro. I've uploaded it as a notepad.

Access Denied - Sucuri Website Firewall
If you are the site owner (or you manage this site), please whitelist your IP or if you think this block is an error please open a support ticket and make sure to include the block details (displayed in the box below), so we can assist you in troubleshooting the issue.

Block details:
Your IP: 98
URL: http://www.excelforum.com/newreply.p...eply&t=1230048
Your Browser: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36
Block ID: EXPVH13
Block reason: Exploit attempt denied by virtual hardening.
Time: Wed May 9 10:25:52 2018
Server ID: 12015

[taylorsm]

Here is the macro that I use to then push out a copy of all.

No clue why this code posts ok.

Please Login or Register  to view this content.

[taylorsm]

Long story short. I need to keep track of the teams. I thought about having each team just have their own separate sheet and then using a Power Query to import them all together but that makes changing teams hard if there are very many because it comes a game of cut/paste and in reality we have closer to a dozen teams.