Analyze some Data

Required: You will receive instructions to automate the process of consolidating data from two different sheets into a master sheet in Google Docs. Sheet one has performance information from different ad campaigns. Sheet two has spend information from different ad campaigns. There are rows that need to be automatically removed based on certain rules from sheet one. Ranges from the lists can be organised from A-Z in order to match the information as long as they are cleaned up first. What's the main objective: Build a simple Google Docs spreadsheet that will perform the above instructions automatically to avoid doing it by hand every day.