setting loop code to check all named sheets

[peter renton]

Hi

Code anybody help me to loop through the sheets.

at the moment the code will look at ppe sheet and check the dates if any due date are found it generates an email and inserts a table in it.
i am trying to have it check the other sheets in the work book forltruck, gas etc so that it would generate other emails with that sheet table in it
hopfully changing the subject line i.e gas insections due, ppe instection due etc.


Thank you for any assistance in advance

Peter