I have dates in columns like this:

25/09/06 02/10/06 09/10/06 16/10/06 23/10/06 etc


And on another worksheet I have:
5000 in cell A1 and then 02/10/06 in cell B1 and 16/10/06 in cell C1

I would like 5000 to appear under the column headings for 02/10/06, 09/10/06, and 16/10/06 in my first worksheet - based on the values in cell A1 and the date range in B1 and C1.

Is there a formula that can do this?

Any help would be very much appreciated. Thanks.