how do I in an Excel 2003 macro...Take 5 workbooks...goto a specific
worksheet in that work book. autofilter on a cell copy and paste that
data in a blank workbook...

Kat