The formula =sum(job1!b15:job6!b15) works if the sheets are not adjacent to each other in workbook.