Apply Auto Filter Based on Date Input by User

I've written a macro (Live recorded) that cuts a date from one cell and pastes that date into the macro. My intent was to have someone (that knows nothing about macros) be able to put a date into that cell and click on the macro button and auto filter would give them all the information for that date (& do several other things also). The macro works the 1st time and then that date stays in the macro no matter what you put subsequently in the cell..How do I get the macro to copy and past the new information put into that cell into the macro each time automatically?