Adding names of users from one column to another and color change to annual cap

[cmgtlg]

I have attached a sample file of what I'm trying to accomplish and hope that you can assist. I'm using Excel 2016 and have multiple tabs indicating each month.

In the Apr 17 tab, I need the users name in Column B to also appear in Column P for each instrument used.

Also, in the Q1 tab, I'd like to list the number of users in Column C and the initials of the users in Column D.

There is a cap to the amount folks will be charged for use so I need the color to change once the user has reached the annual cap amount.

What is the best way to do these tasks?

Thank you.