I have a spread sheet that pulls information from an oracle database. It pulls in a lot of information. I need to break it out on different sheets by date.

Is there a way I can say "If J2 is within the current month then copy it to sheet 2" and "if J2 is the prevoius month coppy it to sheet three" and "garb all rows from the last 12 months from the current month and copy it to sheet 4."