I am creating a totals sheet for the year based off of monthly sheets which
include employees name and salary paid. I have each employee on its own -
same line between the sheets so my totals are fine. However on the total
sheet I would like to pull the employee names onto the sheet. Some months
include different employees than others - each employee no matter what has
its own line - some lines are blank on somesheet. Some employees are on
every month's sheet.I tried

='Jan 04:Dec 04'!A6

and I get #REF returned

Please help,
Barb