Excel 2003 - VBA - Autofilter, more than 2 criteria?

Hello all,
I am trying to autofilter in VBA (Excel 2003), it looks like I am limited to two criteria.. is there a way around this?

Basically I have a list of users and roles, they can have about 50 different roles, I'm trying to have this macro filter out 4 different roles, and copy these users and their roles to a different sheet.

I can do it for two of them no problem, and I know that I could do it twice, but I am trying to keep it simple as I am trying to avoid having to copy them to the different sheet, go back, re-autofilter, go to other sheet, find last row, paste below..

So, basically I know how to do it in a long way, but I also view these as a learning experience so I'm wondering what some experienced people think.. As always, any help you guys can provide is appreciated..

Thanks!

Adam