setting loop code to check all named sheets

[peter renton]

Hi Alan

I have tried every which way to try and get this thing to do what i want but keep screwing it up (i must be thick as it is probably very simple)
the attached selects the ppe sheet and renders the required data in the email table, no matter what i try it only shows the ppe sheet but if i remove the
ppe line it errors, how/where do i add the coding so that it will go through every sheet and render the different data from each sheet into individual email tables.

any help would be appreciated as this is now doing my head in

Peter