Hello can you please ehlp and tell me if possible can excel transfer dat from 5 different sheets to a master list, i have 5 different sheets with different names, each of this sheet contains some items that are similar to anothr sheet but different amount for each, so my question is can excel look in all five and find the item and then sum all in one master sheet for all this if so can you please help!! tahnk you