VBA Beginner loop question

Hi, I just started VBA like 2days ago and I was trying to make a loop that will check contents of first columns in multiple sheets and produce results AND put filter on results.

for example, sheet2 and sheet3 (first columns only) will be checked and produce result in sheet1 first column and put filter on sheet1 first column
and then sheet2 and sheet4 check and result will be in sheet1 second column and put filter on sheet1 second column
then sheet2 and sheet5, result in sheet1 third column and filter also..and so on...

I tried to make a loop but all i could think of was for loops like "For i=1 to 10". But this will just run 10times no matter how many sheets i have..

please can you guys enlighten me how to use loops effectively, not caring about how many times it should run?

this is the code i came up with and still needs code for loop

Please Login or Register  to view this content.