Hi, I am trying to consolidated about 12 worksheets into one. Each worksheet is the month of the year and has the workers name and pay. While the final worksheet has all the months of the years in columns along with the employees name and pay for each month and a total at the end. The problem I am having is that some of the workers are in some months but not others. How would I consolidate them all onto the one yearly report. The cells from each seperate sheet need to be linked to the final yearly report. Any suggestions of how I could go about this!??