Copy filtered data, not header

That line of code means: "go through this list of worksheets one at a time". So it is referencing sheets in the activeworkbook.

Are you getting a subscript out of range error? Check the spelling of the sheets I listed in that array. Either it's spelled wrong in the macro or in the sheet tab.

If you continue to have issues, click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.