can you please help!!

i have a sheet with 4 different tabs each tab containes employees data and i would like to do, is transfer the data into one, this tab will collect all the data ffrom al the for different tabs, what i mean is tha the dat goes like this,
A3= name of the employee
b3= days worked away
C3= days worked in the office
d3= total of days this has a conditional formating to change color if this person worked away more days then in the office and viceversa can i then have a all this information add on into one single tab, this is like in a master employee list it would look and search for the eloyee name and add according to the color like green, for away and red for in house can you please help i could do this manually but this is a pain every month please help!! tahnk you in advance

how do i do that and how does it work