Loop codes through multiple sheets (not all sheets in workbook)

Hi all, good day!

I have a workbook with sheets named from 1 to 30. Apart from that, there's few other sheets as well which are not numbers.

I would like to copy range E2:E341 from sheets 1 to 30 to one of my sheet named "temp" on column B and to the next blank row.

I tried to develop the code but am not sure how to loop thru the sheets from 1 to 30.

Below is the not working codes that i've tried.

Please Login or Register  to view this content.

Appreciate any assistance.

Thank you!

Hi fonzie29,

Thank you for your reply!

I am afriad this code is not working because other than the "temp" sheet, i have few other sheets which should be excluded as well.
If the code 1 to 30 can't work, the only way would be the exclusion of all the other sheets?

Thanks.

for now would be only three sheets.
However, i am not sure whether there will be additional sheets to be excluded.
The sheets named 1 to 30 are fixed, that is why I thought of using that to make it more future proof.

Thanks!

Hi Fonzie,

Thanks for the prompyt reply.
And yupe, it's working smoothly and the result is what I intended.

Thank you very much!