I really need help. I am a newbie to Excel and Macros. See attached spreadhseet:CashFlowExample.xlsm

I need a code that generates data on Sheet 1 (Cash Flow 2015) based on the data on Sheet 2 (2015 Clients).

On Sheet 2, if column D says "Annual", then I want the Annual payment Amount (Column C) to generate on the "Expected Payment Date" (Column F) on sheet 1. For example, Boston EMS should generate $68,100 in Apr-15 on Sheet 1.

if column D says "Monthly", then I want the Monthly payment Amount (Column B) to generate 2 months from the "Start Month" (Column E) through Dec-15 (end of the year). For example, Blanchester EMS should generate $133 Mar-15 through Dec-15.

Essentially, I want the macro(s) to make Sheet 1 (Cash Flow 2015) to look like Sheet 3. Sheet 3 is only there for display purposes and will be deleted.

I want the sheet to also:

- Automatically update Sheet 1 if I add a customer to sheet 2.
- Automatically update Sheet 1 if I delete a customer on sheet 2.
- Automatically update Sheet 1 if I change the payment amounts in Columns B or C.
- Automaticaly update Sheet 1 if I change column D (Annual to Monthly or vice versa).

Is this going to be possible?