I have 5 workbooks that i need to go to a sepcific worksheet do an
autofilter on a specific cell then coping and pasting that range into
a new work book.

If you could help I would appreciate it.

kat