Hi

I need help again. I would like to know how do i select the last 5 sheets.

for example I have sheet:

1 2 3 4 5 6 7 8

and i would like to only run a macro on the last 5 sheets.This macro is being run on a weekly basis. keeping in mind that the naming of the sheets may vary everytime i run the macro..so any help please?