Attendance Point Tracking Worksheet, need some help with finishing touches.

Ok, so this is the worksheet I currently have, but it is not quite where I'd like it to be. First off, I would the summary page, to only show points earned from Today, and everything in between from one year of Today. I am a novice on Excel, but I've dissected what this one started out to be, and made it work wonders for me. Minus that one issue, but now that 2014 is over, I want to be able to track each month separately, and I'd like my 2015 tab, to be updated from my '2015 JAN' .. '2015 FEB' .. etc.. and lock the actual 2015 tab, so that it cannot be messed with accidentally. Keeping the '2014' and '2015' tab are important, because it makes the summary formula's easier on me.

Any insight on what I need to do would be greatly appreciated.



EDIT: And here I have a more finalized version of what I'm after. Minus the ability to directly convert the data to show only the Year to Date points.Attendance Tracker Online Help V2.0.xlsx

J6=IFERROR(IF(INDEX(INDIRECT("'2015 "&TEXT(J$5,"MMM")&"'!J1:AN100"),MATCH($B6,INDIRECT("'2015 "&TEXT(J$5,"MMM")&"'!B:B"),0),DAY(J$5))=0,"",INDEX(INDIRECT("'2015 "&TEXT(J$5,"MMM")&"'!J1:AN100"),MATCH($B6,INDIRECT("'2015 "&TEXT(J$5,"MMM")&"'!B:B"),0),DAY(J$5))),"")

Try this and copy across

Yes, No change it will the same for 2014 and 2015 or any other year

Year-to-Date Summary Sheet in Cell B3 You have January 13, 2015 for this you want to get data from 14-1-2014 t0 13-01-15 am i right?

see the attached file

Yes, you are right.

If you need to start it at from 1-4-14 and continue it to liked date, change the date in Year to Date Summery sheet, it will automatically change the dates in "Getting Data" Sheet.

Yes, you can, only thing is change the dates in "Year to date summery" sheet only, no need to change dates in Getting Data Sheet,
Ply with the work book by change the dates in Year to date summery sheet, you can see the changes in Getting Data Sheet.

you are welcome

Please ignore my earlier attachment
in that year "2015" entered manually in the formula, now it was taken with formula.
see the attached file, i try to say something about the formula how it will work, i hope you understood with that.