Forum Discussion
Help with productivity worksheet
First, let me advise that you take down your sample spreadsheet, because it contains the names of actual employees and thus violates the terms of this public forum.
Second, having looked at it if only very briefly, I can tell you that you (your company, your department, whatever) are making a common mistake in keeping your records on separate worksheets for each month. That makes it a lot harder for Excel to do what it excels at doing--taking a large set of data and analyzing it. A LOT HARDER.
That final report you're wanting to create would be a piece of cake with a single function (FILTER) if your data were all on a single sheet. I'm going to create an example for you (since I've already opened the file), and will post it back here without the names of real people.
But if you get to this before hand, please take down your original sample file and replace it with one that substitutes the names of Disney characters or Star Wars characters or Jane Austen characters--your choice.