You need to create a Pivot table using the "multiple consolidation ranges"
option. This web sit eis a good place to start to learn how but by all means
do a google search on "multiple consolidation ranges"
http://www.contextures.com/xlPivot08.html

HTH Marty


"babs" wrote:

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