I'll be honest, I'll help you but I won't teach how to program, I'll teach how to link excel to access and apply filters on the data you've just brough from Access.
First of all, go to sheet2 (is the place where we~ll link access to excel). As you didn't say Excel no Access version, I'm assuming you're using 2007 or 2010 version as they behave equal. The procedure is more or less equal to previous versions but using menus not tabs.
Go to tab Data, On the part that says get external data, choose Microsoft Access and select the file you want to use.
It will show you the list of tables and queries, and you should select the query you want to use.
After pressing ok, choose the cell where you want put your data.
This will bring all the data to Excel. After this, it~s only a matter of right click on data and pressing Refresh on popup menu to refresh data (updating the information adding and/or removind rows).
Now, go to the right side of your data, for example z1 and type the same name of the column you want to filter, on z2, type the data you want to user to filter data.
Choose a single cell from the data you've just brought from Access and go to tab Data. Press Advanced Filter.
It will automatic choose the whole intervall, on the new screen, on the second textbox (criteria range), type z1:z2 (the place where you've typed your criteria and press ok.
For a new round, right click on your data and press refresh. Type a new criteria on b2 and rerun the advanced filter steps to filter the data the way you want.
Hope it helps.