Automatically fill in data based on multiple criteria from another spreadsheet

Hi,

I am in way over my head and wondering if anyone can help me.

I have one workbook with 2 tabs (2 worksheets). See attachment, it looks like this:

First tab:

3 rows - Client 1, Client 2, Client 3

12 columns - January 2015 - December 2015

Second tab:

3 rows - Client 1, Client 2, Client 3

2 columns - Monthly Revenue and Start Month

I want the 1st worksheet to automaticaly fill in the monthly revenues for each client based on the start month listed on the 2nd worksheet. Monthly revenue is always 2 month from the start month.

I want it to automatically update the data in the first worksheet everytime I add a new client to the 2nd worksheet. Is this even possible?

At first, I was trying to use MATCH and INDEX, but I really think I need macros.

I am a newbie and appreciate any help I can get.


Thanks so much,

Trinh