number of sheets

Good afternoon all. I am trying to figure out how to read the sheet tab name in a workbook where the number of sheets may vary. What I want to do is to 'trim' the names so in a case if I am looking for "JULY16", and the sheet name it "JULY16 " (notice the space,) it wont crash the program. Yes...