Hi everyone, I have been searching and googling for days now and can't seem to find the right fit for what I need to do. I have tried piecing together different formulas that I could find, but I just can't seem to get it to work the way I want.

What I am trying to do is make a macro that will search for the word "Voice" and then copy the next 5 rows to a new sheet. I have found plenty of macros that will do this, but I can't seem to figure out how to loop it to the end of the sheet and find each instance of the word "Voice".

For example:

Sheet1 would look something like this:

| Column A |
_____________
1 Voice
2 123
3 456
4 789
5 011
6 121
7 314
8 151
9 617
10 181
11 Voice
12 920
13 212
14 223
15 242
16 526
17 272
18 829


So then in Sheet2 it would look like this:

| Column A |
_____________
1 123
2 456
3 789
4 011
5 121
6 920
7 212
8 223
9 242
10 526


... and this would repeat on until the last line in Sheet1.

I appreciate any insight and help,
Thank you!

Jon