Macro to search all worksheets and list those containing a certain text value

I've been trying to work on this for two days with little success. What I want is basically just a cut and paste option to the Find function. I want to search my 100+ worksheets for any instances of certain text- for example VOUCHER 6 (it will always be in row 3 if that matters) and give me a list of the worksheet titles.

A huge bonus would be if there could be a third column that would return the data two cells above the words VOUCHER 6.

So I would end up with a new worksheet called VOUCHER 6 (and then VOUCHER 7, VOUCHER 8 etc.) that looked like this:

Farmer Name Total Coupons

Farmer 1 456
Farmer 2 24
Farmer 3 1587

Farmer 1 2 and 3 are the worksheet names and 456 24 and 1587 are the numbers two cells above the text VOUCHER 6 in each worksheet respectively. If anyone can help with this and/or point me in the right direction that would be amazing.

You are a genius! This worked perfectly!!! Is there any way to make the new sheet called VOUCHER 6 go at the end of all the other worksheets vs. at the beginning? If not, no biggie. Also, is there a way to set it to autototal all the numbers in the B column or not since we don't know how long it will be? Thanks a lot for the help.

Is there a way to modify it for that (that isn't too hard). I can manually add those but having them in the voucher would be amazing!