pull data from list

Hi everyone   I'm very much a beginner with excel and I'm in need of some help.   I'm currently using an excel sheet for work that pulls data from various other excel sheets and i wanted to creat...