Help with a change macro

[brian0721]

I was wondering... I have a database that does many reports for individuals by month, and other time frames. Is there a way that i can make a macro that will copy certain reports/queries, and in queries it could change the criteria, and in reports change the record source? Help would be greatly appreciated. Thanks!