Hi all!

I'm very new to Excel and all it's possibilities. I'm comfortable with the Windows OS, Word and Outlook but quite clueless when it comes to Excel things. I've done most of the "Excel 2010 for dummies" book but it doesn't seem to go in depth enough for what I'm trying to do.

We have 30 employees and I have been given an Excel file to work with. It has the days of the month and the names of the employees on 12 sheets, then a summary page with Name, Dept, Hire date, Today's date, # of days employed, Vacation accrual hours/day, hours accrued, total hours taken as of Dec 31 09, Total hours taken in 2010, Total hours taken in 2011, total hours taken as of (today's date), hours balance, hourly rate, Value of Vacation and annual Salary.

I'm supposed to make a simpler easy to work with file and I'm quite overwhelmed with the whole thing. I can make a pivot table out of the summary page but not out of the monthly pages.

It's hard to picture, but does anyone know of ways I can make it more user-friendly? Also I'm not sure why I can't make the monthly pages in to pivot tables.

Thank you in advance!!