Excel Sheet Count and Parsing Data from Sheet title

[Jwats36]

I am trying to learn how to count sheets in excel and need a sheet count for certain parameters. The version of choice is 2003 and it would be prefered if we didn't have to use a macro/vb code.

The first cell i need to be able to parse out the last character from the name of the sheet.
Ex.

I have many sheets with data from each month. Titled as so...
Jan pg1, Jan pg2, Jan pg3, Feb pg1, Feb pg2, Mar pg1, etc....

I need the page number in a cell on that sheet for report printout usage.

The second cell uses the same example from above only i need to count the number of pages for that particular month. I have looked at a few other forum posts that show how to find how many sheets are in between 2 sheets. I didn't find an answer i liked and this sheet will be edited and added to each time a new sheet is needed.

If there is a simple VB answer it is greatly appreciated as well as just formulas if its possible to do any part of this using them.

Thanks in advance,
Josh

 

[Jwats36]

I figured out how to do the number of the sheet im currently on.

=RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256))

Gives the last character of the current sheet name.