Excel 2007 : Populating a pivot table on the basis of listboxes selection.

Hello guys,
How are you all??
This is my first post , I am struck at one point.
I have some already populated lists and I want when user selects different values on from different lists and clicks on a button, data which is in a different sheet gets filtered on the basis of selections and then a pivot table gets populated with the filtered data.
Can anyone help me with this, seems to be quite tough for a beginner like me

I want to do it programmatically.