Have you looked at AutoFilter?
If you filter column I on PASS, select everything that you see and paste it to the PassSheet, only the Pass rows will be copied.

Macros work fine on a Mac. That's what I use.