Im so stuck

Hi, I have a speadsheet that allows me to calculate they ammount of dirt moved due to how many trucks I have and the cycle time for each truck. On another sheet I have a roster set up, am I able to use it so that the roster sheet only finds the people that are due in between 2 dates minus annual leave people then distributue them onto the machines they operate and then onto the sheet that calculates according to how many trucks i can run when all other esential equipment is manned up, i.e diggers dozers water carts etc etc. Each crew crew 1 , 2, 3 are identified with coulered txt but when i bring them onto the sheet to put them onto a piece of equipment via drop down menu they dont come across in the same colour making it hard to identify which crew they are on, can coloured font be brought across to another sheet via drop down menu?
At the moment I have a sheet that has what operators are competant on each piece of machinery but i cant hide the guys who are on annual leave etc.
Then I would like it to identify if im short of operators raisng a alarm prompting the authority to recruit.

I know im asking a lot but any help would be much appreciated.