Comparing columns in 2 different worksheets?

Hello all, I have a workbook, 1 sheet is Raw Data, in which I import data from a sharpoint site. It displays the following columns

Resource Name -- Absence Type -- ID -- Start Time -- End Time -- Created -- Modified by

The next sheet I have is tracking, it's called Tracking. On this page the user imputs Resource Names they want to track into Column A

I need a way to loop through Raw Data and compare Resource names to those in the Tracking page. I know the logic I need to use, but what I dont know is the syntax to refrence the pages together. Any insight on the best way to accomplish this task?

Thanks ahead of time ExcelForums!

Yes, I made a mockup of what I'm working with. The goal is to have the names compared then absence type refrenced and a count added to the correct column, but babysteps... Once i figure out how to compare the two columns I think i can make great strides.