Trying to find the last non-empty cell in a specific row/range over multiple sheets

I am working on an attendance workbook of sorts in Excel 2013. The workbook contains a Calculations sheet, a Lists sheet and a sheet for each month of the year. The Lists sheet has a list for names and a list for the months. I have included a link to a sample workbook to demonstrate how the sheets are setup and the basic functions, names, lists, etc that I am using.

My sample workbook:
https://app.box.com/s/mgvums1vmnmnec7e7d0p4vi5daoyo5nv

When looking for the last non-empty cell in a specific row/range, I receive the correct result when I use the following LOOKUP on each specific Month sheet: (Which I found after some digging on a few sites) =LOOKUP(2,1/(C5:AG5<>""),C$4:AG$4)
- For the Month of Feb, the last entry in the range C5:AG5 is in AA5, which is the 25th.

I also receive the correct result when I use the following Lookup from any non-Month sheet: =LOOKUP(2,1/(Feb!C5:AG5<>""),Feb!C$4:AG$4)

That being said, the two specific issues I am running into, are as follows:

1. I have been unable to work out how to come up with the last non-empty cell (which is the last marked day of attendance) when using Name and Month information selected in the Combo Box/Form Controls. Simply said, in my sample workbook, I want to know the last day in Feb that Johnny was in attendance.

I've tried starting simple, just using the "Month" I selected. I tried a few different itterations of the following:
=LOOKUP(2,1/(Month&"!C5:AG5<>"""),Month&"!C$4:AG$4")
The closest I've gotten was the above Lookup, which ends up turning into what you see below (when viewed in Calculation steps). It of course returns a #VALUE! error.
=LOOKUP(2,1/"Feb!C5:AG5<>""",Month&"!C$4:AG$4")

2. I have been unable to work out how to come up with the last non-empty cell across all the Month sheets when using the selected Name from the Combo Box/Form Control. Basically, I want to know the last day of the year that Johnny was in attendance. In this sample workbook, that would fall on April 11th. I understand that the formula would just return "11". I believe I can format the result after the fact, using the resulting sheet name. (In this sample case, Apr)

I am fairly certain I will need to use a VLOOKUP. I just can't seem to break the barrier between the general concepts of what I want and the proper way of formulating it.

Any help would be appreciated. I'm feeling pretty lost at the moment. If you need more info from me, please let me know.

Thanks,
Kurewe

Tony,

Thanks for the reply.

Yes, I did set a Cell Link. So, the Name Selector is linked to Lists!$A$1.
Lists!$A$2 then has =INDEX(NameList,A1,1)
Lists!$A$2 was then setup in Names Manager as "Name"

I did the same for Month as well.

Thanks,
Kurewe

In my sample sheet:

Please Login or Register  to view this content.

Should have been returning the Month name in this:

Please Login or Register  to view this content.

However, after I entered the formula, it returned something like:

Please Login or Register  to view this content.

Which, gave a #VAlUE! error. It replaced the 2nd "(" and the 1st ")" with quotation marks.

Failing to be able to resolve that led me to finally posting for assistance. I actually received a solution from another site that appears to do exactly what I needed to do. You can take a look at the solution using the following link.
Working Solution

Tony,

I just received the following, which is far more simple than what was provided in the link I shared. These are much closer to what I was hoping for. Only issue is that the 2nd LOOKUP below only gives the Month of the last entry. I replied to the poster and asked if there was a way to have it return Month and Day (i.e. "APR 11" or the less preferable "11")

This one results in the last attended day for the chosen name and chosen Month

Please Login or Register  to view this content.

and

This one should result in the Day # or the more preferable Month & Day # for the last entry of the year. Currently, only results in the month of the last entry of the year.

Please Login or Register  to view this content.