Duplicate rows

Hi, everybody
I hope some of you could help me with this problem. I'm not a macro expert and I couldn't find any solution on the web yet.

I have an Excel file that looks like this:

mickey mouse	2008	5000
donald duck              2007	7000
donald duck              2008	8500
donald duck              2009	1000
daisy duck	                2006	50000
daisy duck                2007	15000

and I need a macro which creates duplicate rows for every person, filling the missing years until the current year.
So the result for this example should be:

mickey mouse	2008	5000
mickey mouse	2009	5000 <-- added
mickey mouse	2010	5000 <-- added
donald duck   	2007	7000
donald duck   	2008	8500
donald duck   	2009	1000
donald duck   	2010	1000 <-- added
daisy duck	    	2006	50000
daisy duck    	2007	15000
daisy duck    	2008	15000 <-- added
daisy duck	    	2009	15000 <-- added
daisy duck    	2010	15000 <-- added

Any help is appreciated!
Thank you