Link Excel record across sheets

I am cursed with an Excell report that was dumpped in my lap. Using anything but Excell is not an option. I have a first QTR report with truck maint, and I have second QTR. I have to do a Year to date. The problem is they have four locations with multiple departments and these trucks get moved between them. What I need to do is to be able bring a trucks information from the Qtr reports to the YTD no matter how the Qtr is sorted. I Have to follow the format of all of the qtrs and ytd in one work book. Can I link my cells by the trucks serial number so no mater what location or dept it is in it will show corectly on my YTD?