setting loop code to check all named sheets

[alansidman]

do i just need to add this at the begining of my existing code removing the select ppe row and the next w at the end

Yes.

Here is a link on this concept.

Macro to Loop Through All Worksheets in a Workbook

[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