Hi - I am a macro newbie and I think this is beyond me. :/

I've been trying all day with no success to make a macro that will copy data from all columns of one workbook containing specified header text to a single column in a different workbook.

So for example, I've got a workbook called coupon barcodes that has multiple tabs for each person redeeming coupons on sheets 2-88 (sheet one can be skipped) and some of the columns are labeled "voucher 1" in with a list of all the coupon barcodes that customer redeemed below that. I want all of the data from all of the columns in this workbook that have the header "voucher 1" to be copied and pasted into one column (order doesn't matter) also labeled "voucher 1" in another workbook I have open called vouchering database. Or even if they were just pasted into one column within the same worksheet so I could copy paste.

There must be a way to do this that is easier than searching the internet all day again tomorrow lol. Can anyone help?

Thanks for you time.

~Mamagregory