Sales Commision Worksheet Solution to Multiple Outcomes

[pinas]

I am having a problem coming up with a formula that will pull information from multiple sheets with different outcomes. I need the payroll worksheet to correspond with the appropriate date to be paid. Lets say the pay date is 03/27/13 I need the sheet to separate everything into the appropriate columns (i.e. salt, bank draft and install commission) at the same time I need any previous weeks other than the ones separated into week one or week two to fill based on pay date as a total under "installs from previous weeks" I may be making this more complicated than it should be but I need all information to auto fill into the worksheet (that must stay the same) and our salesman needs to be able to separate his work weeks