combine worksheets and highlight names across sheets

i have like 4 excel documents that are lists of companies. when the same company appears in the various lists, i want them to be highlighted automatically. i cut and paste a new list into each document daily, so i want the excel sheet to be active. when the same company name ("ticker") appears in Volume % and Most actives, highlight the company green in both lists. If it appears in the if it appears in volume % and Money flow, make it red in both lists. If it in Most actives and Money flow, also make it red. If it in all three lists, make it yellow