Excel 2007 : Copying entire rows of data if a cell meets certain criteria

Hi,

I'm currently responsible for an organization's budget. I have a main banking report on Sheet1 that lists all the checks written with columns containing date, check #, amount, and the part of the budget it was for. I then have a sheet for each part of the budget. I would like to figure out a way to automatically copy an entire row of the data from the banking report to the sheet that it specifies. For example if I enter check # 101 on 1/1/2011 for $500 and its apart of the President's budget I want the entire row to be transferred to the President's budget separate sheet, but still remain on the consolidated banking report. So kind of like an 'if column E contains "President" then copy the row containing "President" to Sheet2 into a table.' There would be multiple instances that check will be written for the same part of the budget, so I would need all instances of President to be copied to the separate table. I know it kind of sounds confusing so I will try to clarify if need be. I'd appreciated any guidance greatly!!

Here's an over simplified version of what it looks like... The headings are the same on all of the sheets. I appreciate you taking a look at this!