Dynamically filter to another worksheet using Excel: Mac 2011

[charlesstricklin]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #003ecc}</style>I have a worksheet of all of my students in A:H. In column D I have the class period for each student. I'd like to dynamically filter each class period to its own separate worksheet, i.e. 2nd Period, 3rd Period, etc.

I've learned if I were using a Windows version of Excel, I could download the Power Query plugin to accomplish this, but I'm using the Mac 2011 version.

Is there a way to accomplish this?

 

[charlesstricklin]

UPDATE: I've come up with copying =IF(OR('Current Students'!$D2<>2,ISBLANK('Current Students'!A2)),"",'Current Students'!A2) to every cell I use, changing the column from A through H automatically, and that seems to work, but is there a more elegant, efficient way?

UPDATE TO MY UPDATE: No, that doesn't work because it doesn't allow for the changing row numbers past my first class period (3 through 7.)