@ Utahguy, that formula pulls inteh sheet name - which is then used as the month criteria. I put that in E1 to pull in the sheet name so that you dont have to hard-code the month name in the formula
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

@ Punnam, sometimes thats just how the data comes in The TRIM() function generally takes care of leading and trailing spaces