Excel Help Please

Hi Everyone 

hoping some one can help me out i am trying to pull information from multiple spread sheets in to another spread sheet using word references and could do with the formula help please