I need to find a way to in a sense query off of a spreadsheet in excel.

I have 4 criteria that a user will need to enter (for 4 separate columns)
into a sheet and then paste rows matching that criterion to a new worksheet.

I was thinking to use activeX text boxes to allow entry of the said
criteria, but not sure how to make VB look at a certain cell for criteria
instead of a fixed refernce.

Any help / guidance would be greatly appreciated.