Dropdown Boxes?

Hi all,

I am creating a database that lists our University's Professors' papers... they are categorized as "Working" or "Published". I have made the dropdown boxes with those options already. What I want is to have one sheet list all of the papers that were categorized as "Working" by means of the dropdown box and other sheet list all of the papers that were categorized as "Published", by means of the dropdown box. I'd like it to be "automated", where the paper automatically goes to either the working or published sheets as soon as I click one of those two categories in the dropdown box. Is this possible? Please advise.

Spreadsheet.jpg

Thanks in advance,
Sarah

mrice has a good point. See attached :

Once sorted as desired, you can print what you see, not what you don't see, if you need a hard copy, etc.