Adding Tabs of Same Sheet How to Update Summary Tab

**awang429** · 12-12-2008, 07:18 PM

I am using a great Excel template posted on the MS Website. The first tab
(meant for a single employee) is a calendar for 2009 and you can code what
kind of absences that employee has thorughout the year. The worksheet totals at the bottom and it also links to another Summary tab.

The problem is that There is only ONE employee tab in the template. Is
there a way to add a tab for each employee and efficiently update the Summary tab? of do I have to hardkey a tab and cell number in each cell in the summary page?

I am using a Excel 2009 spreadsheet converted to my 2003 Excel. The
template on the microsoft site is called "2009 Employee Attendance Tracker"

Thanks

**Richard Buttrey** · 12-12-2008, 07:30 PM

Hi
Not quite sure what you're getting at, but if the data sheets are consistentky laid out, the generic formula for a summary is
=(Sheet1:Sheet12!A1)

HTH